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

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

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”.


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

phpmyadmin export XML

Export MySQL Database table as an XML Document

To export a MySQL database table as an XML document, you can use mysqldump command like phpMyAdmin table export feature


MySQL ERROR 1114 (HY000) at line 2137: The table ‘X’ is full

When restoring a MySQL database, I get the following error How to fix ERROR 1114 (HY000) table is full? First,


ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails

When deleting a table in a MySQL database, I get the following error message To fix the error, run Now


MySQL show processlist

To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run the command To see


MySQL Backup

MySQL backup all databases Split mysqldump backup file into tables Extract Backup of one database from mysqldump all databases MySQL


MySQL backup all databases

To backup all databases on a MySQL server, run This will create sql backup file for each database in your


bash: mysql_safe: command not found

On CentOS 7 server running MySQL 5.7, when trying to reset MySQL root password, I get an error This is


CentOS 7 MySQL 5.7 root password reset

To reset MySQL 5.7 root password on CentOS 7 server, do the following Stop MySQL Server Set the MySQL MYSQLD_OPTS