How to Migrate MySQL Users to Another Server

I wanted to Migrate MySQL from one server to another. Usually, I could just copy over the MySQL data directory

How to disable MySQL X Protocol (mysqlx_port)

After installing MySQL 8 and checking listening ports with “netstat -lntp”, you will see MySQL is listening on ports 3306

Limit disk used by MySQL binary log files

On a server, the disk was almost full. On checking most of the disk space is used in “/var/lib/mysql” folder,

How to Install MySQL 5.7 on Ubuntu 22.04

MySQL 5.7 is not supported on Ubuntu 22.04, but you can download MySQL 5.7 for Ubuntu 18.04 and install it

How to create MySQL data directory with mysql_install_db

On a Debian 7 server, the MySQL database got corrupted, which caused the MySQL database to keep crashing. I was

How to Repair MyISAM Tables

MyISAM tables (.MYI and .MYD) can be repaired using myisamchk command. To find list of corrupted tables To rapier a

mysqldump errno: 24 Can’t open file when using LOCK TABLES

When backing up a MySQL database using mysqldump command, I got the following error. The error is due to open_files_limit

How to fix InnoDB: ERROR: the age of the last checkpoint

On a MySQL server, the error log keeps getting the following error message The error is because you are trying

MySQL 8 Your password does not satisfy the current policy requirements

When transferring a website from one Cpanel server to another server running MySQL 8, I got the following error message

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