MySQLTunner is a Perl tool that you'll assist you and tuning your MariaDB/MySQL database server. It checks many parameters of the server, verifies user passwords, checks for anonymous users, insecure passwords(where for example the password is the username), checks for…
If you don't have a GUI interface for your database server - like phpMySQL for example - you can create MySQL/MariaDB users and databases from the command line. 1. Authenticate as the MySQL root/admin user # mysql -u root -p…
From the control panel interface If you have access to a control panel like cPanel, DirectAdmin etc, the easiest way is to check the MySQL section. For example, in cPanel, simply navigate to MySQL® Databases section and you will see…
This error means that the MySQL/MariaDB server is not able to process the request. You will see in the error_log files entries like: [21-Feb-2020 21:34:00 UTC] PHP Warning: Error while sending QUERY packet. PID=4697 in /home/flighting/public_html/wp-includes/wp-db.php on line 2030 [21-Feb-2020…
Exporting a database can be done very easily from phpMyAdmin/ from your web hosting control panel (cPanel, DirectAdmin, VestaCP etc). But you can also export databases from the command line with the mysqldump utility. With mysqldump you can export a…
Some clients asked us if you can set up only database backups in WHM. For some, this will sound strange, but there are users who want such a feature. You can access WHM backup settings via WHM->Backup->Backup Configuration. Unfortunately, there is…
