Category: MYSQL

MariaDB/MySQL …Invalid grant string: SET DEFAULT ROLE 0 FOR

Symptoms When accessing cPanel >> MySQL Databases you receive an error with the following: The MySQL server is currently offline.adminbin Cpanel/cpmysql/DBCACHE: exit 255" Description  Whenever there is an issue with...

Read More

How To Move MySQL Data Directory On A Separate Partition

Prerequisite: A free partition that will serve as a dedicated MySQL partition. Note: These instructions assume that the partition you wish to mount is /dev/sdc1 Backup all MySQL databases Code: mysqldump...

Read More

How To Back Up Your MySQL Databases

MySQL is an open source relational database management system (DBMS) which is frequently deployed in a wide assortment of contexts. Most frequently it is deployed as part of the LAMP Stack....

Read More

How To Use MySQL Query Profiling

What is the MySQL slow query log? The MySQL slow query log is a log that MySQL sends slow, potentially problematic queries to. This logging functionality comes with MySQL but...

Read More