How to fix InnoDB: ERROR: the age of the last checkpoint
On a MySQL server, the error log keeps getting the following error message 221024 17:50:03 InnoDB: ERROR: the age of the last…
MySQL
MySQL 8 Your password does not satisfy the current policy requirements
When transferring a website from one Cpanel server to another server running MySQL 8, I got the following error message Cpanel::Exception::Database::Error/(XID u99as8)…
Change MySQL root password in Webuzo
Webuzo stores MySQL root password in file /var/webuzo/my.conf If you changed MySQL/MariaDB root password outside of Webuzo, you need to update this…
Change MariaDB user password
To change the MariaDB root password, log in to MySQL as the user root mysql -u root -p Enter your current password…
How to create MySQL read only user
To create a MySQL database user with read-only access to a database, use the following command GRANT SELECT, SHOW VIEW ON DB_NAME.*…
MySQL Could not create unix socket lock file
When trying to reset MySQL 8 user root password, I got the following error message in the log file (/var/log/mysql/error.log). [System] [MY-010116]…
MySQL 5.7 Community Server GPG keys already installed but they are not correct
On a CentOS 7 server, when updating software packages with the yum update command, it fails with the following error message. warning:…
How to install MySQL 5.6 on CentOS 7
CentOS 7 come with MariaDB, a drop-in replacement for MySQL. In some cases, you need to install the Oracle MySQL server. Download…
MySQL Specified key was too long; max key length is 767 bytes
When restoring a MySQL database, I got the error “Specified key was too long; max key length is 767 bytes”. user@host [~]$…
Disable MySQL Replication on Slave
To disable MySQL Replication on the Slave server, first, edit MySQL configuration file, usually in /etc/mysql folder, remove entries like server-id =…
Export MySQL Database table as an XML Document
To export a MySQL database table as an XML document, you can use mysqldump command like mysqldump DB_NAME TABLE_NAME –xml phpMyAdmin table…
MySQL ERROR 1114 (HY000) at line 2137: The table ‘X’ is full
When restoring a MySQL database, I get the following error root@localhost:~# mysql -u sok_user -p’serverok123′ sok_db < parkingcupid.sql ERROR 1114 (HY000) at…