How to Recover MySQL Table Structure from .frm File
To recover MySQL table structure from .frm file, you can use dbsake. You can find dbsake documentation at http://dbsake.readthedocs.org/en/latest/. To install dbsake,…
mysql
How to change MySQL Datadir in Cpanel Server
If the disk partition that stores MySQL data directory runs out of disk space, you may need to consider moving the MySQL…
Free MySQL Database Hosting
Looking for a free MySQL hosting solution? In this blog post, I will list some of the MySQL hosting providers that offer…
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 (/var/lib/mysql) to…
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 and 33060.…
Limit disk used by MySQL binary log files
You can use following config to keep 2 days bin log After modifying the configuration file, you will need to restart the…
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 on Ubuntu…
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 able to…
How to Upgrade MySQL/MariaDB in WHM cPanel Server
cPanel server supports MySQL and MariaDB. In most cases MySQL and MariaDB are compatible, you will be fine with either of them.…
How to fix InnoDB: ERROR: the age of the last checkpoint
On a MySQL server, the error log keeps getting the following error message 221024 17:50:03 InnoDB: ERROR: the age of the last…
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 Cpanel::Exception::Database::Error/(XID u99as8)…
Change MySQL root password in Webuzo
Webuzo stores MySQL root password in file /var/webuzo/my.conf If you changed MySQL/MariaDB root password outside of Webuzo, you need to update this…