MySQL

When restoring a MySQL database, I got the error “Specified key was too long; max key … MySQL Specified key was too long; max key length is 767 bytesRead more

CentOS 7 come with MariaDB, a drop-in replacement for MySQL. In some cases, you need to … How to install MySQL 5.6 on CentOS 7Read more

On a CentOS 7 server, when updating software packages with the yum update command, it fails … MySQL 5.7 Community Server GPG keys already installed but they are not correctRead more

When trying to reset MySQL 8 user root password, I got the following error message in … MySQL Could not create unix socket lock fileRead more

To create a MySQL database user with read-only access to a database, use the following command … How to create MySQL read only userRead more

To change the MariaDB root password, log in to MySQL as the user root mysql -u … Change MariaDB user passwordRead more

Webuzo stores MySQL root password in file /var/webuzo/my.conf If you changed MySQL/MariaDB root password outside of … Change MySQL root password in WebuzoRead more

When transferring a website from one Cpanel server to another server running MySQL 8, I got … MySQL 8 Your password does not satisfy the current policy requirementsRead more

On a MySQL server, the error log keeps getting the following error message 221024 17:50:03 InnoDB: … How to fix InnoDB: ERROR: the age of the last checkpointRead more

When backing up a MySQL database using mysqldump command, I got the following error. root@server12:~# mysqldump … mysqldump errno: 24 Can’t open file when using LOCK TABLESRead more