Change MySQL root password in Webuzo
Webuzo stores MySQL root password in file If you changed MySQL/MariaDB root password outside of Webuzo, you need to update
Change MariaDB user password
To change the MariaDB root password, log in to MySQL as the user root Enter your current password when prompted.
How to create MySQL read only user
To create a MySQL database user with read-only access to a database, use the following command In the above SQL
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).
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
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