MySQL

When I try to connect to a MySQL 8 server, I get the following error root@ok:~# … ERROR 1045 (28000): Plugin caching_sha2_password could not be loadedRead more

To reset MySQL 5.7 root password on CentOS 7 server, do the following Stop MySQL Server … CentOS 7 MySQL 5.7 root password resetRead more

On CentOS 7 server running MySQL 5.7, when trying to reset MySQL root password, I get … bash: mysql_safe: command not foundRead more

To backup all databases on a MySQL server, run This will create sql backup file for … MySQL backup all databasesRead more

MySQL Backup Backup Services MySQL Backup Tricks MySQL Restore Errors MySQL Backup Errors

To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run … MySQL show processlistRead more

When deleting a table in a MySQL database, I get the following error message MariaDB [thrkhztbpt]> … ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint failsRead more

When restoring a MySQL database, I get the following error root@localhost:~# mysql -u sok_user -p’serverok123′ sok_db … MySQL ERROR 1114 (HY000) at line 2137: The table ‘X’ is fullRead more

To export a MySQL database table as an XML document, you can use mysqldump command like … Export MySQL Database table as an XML DocumentRead more

To disable MySQL Replication on the Slave server, first, edit MySQL configuration file, usually in /etc/mysql … Disable MySQL Replication on SlaveRead more