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

MariaDB

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

MySQL MariaDB

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 MariaDB

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,

MySQL MariaDB

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

MySQL show processlist

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