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 MariaDB [thrkhztbpt]> drop table users; ERROR 1451 (23000):…
MySQL
MySQL show processlist
To see currently running MySQL processes, login to MySQL server, run in MySQL command prompt, run the command show processlist; To see…
MySQL Backup
MySQL Backup Backup Services MySQL Backup Tricks MySQL Restore Errors MySQL Backup Errors Back to 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 MySQL server…
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 [root@SAU-8E161-OR ~]# mysqld_safe –skip-grant-tables…
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 systemctl stop mysqld Set the MySQL…
ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded
When I try to connect to a MySQL 8 server, I get the following error root@ok:~# mysql -u serverok -p’PW_HERE’ -h db-mysqlserverok.in…
Magento catalog_product_relation MySQL Error
On transferring a Magento website Database running on MySQL 5.7.34 to MariaDB 10.2.39, I get the following error [root@server52 etc]# mysql buildingplans_m1…
MySQL Cluster
MariaDB Replication MariaDB galera cluster https://www.percona.com/software/mysql-database/percona-xtradb-cluster Disable MySQL Replication on Slave
How to Reset Root Password in MySQL 8.0
If you forget the MySQL root password on MySQL 8.0 server, you can follow the instruction here to reset the root user…
MySQL 8 server requested authentication method unknown to the client
On a server running MySQL 8 and PHP 7.3, I get the following error boby@sok-01:~$ php 1.php PHP Warning: mysqli_connect(): The server…
How to rename a MySQL database table
To rename a MySQL database table, login to phpMyAdmin or MySQL command line, then select the database, run following SQL command ALTER…