cPanel MySQL/MariaBB error: adminbin Cpanel/cpmysql/DBCACHE: exit 11
Because of Bug in the CPanel release lots of our client are facing issue that MySQL is showing down in cPanel interface. But the MySQL/MariaDB was still running. It’s only…
How to Install MariaDB on FreeBSD
to install the MariaDB database manager and to validate which components are available for the MariaDB databases we will execute the following command. We can see the various options available.…
How to Restore One Database From All Database mysqldump
In this tutorial we are going to learn how to restore single MySQL database from a mysql backup file, which contains multiple databases. What if you backed up all databases…
resetting MySQL admin password in Plesk windows
Attempts to manage customer’s MySQL databases produce errors: Error: Connection to the database server has failed because of network problems: Try to establish connection failed The MySQL server is marked…
How to install mytop on CentOS 7 to monitor MySQL processes
Mytop is an open source, command line tool used for monitoring MySQL performance. Mytop program provides a command-line shell interface to monitor real time MySQL/MariaDB threads, queries per second, process…
Install and Configure MySQL Workbench on Ubuntu Linux
MySQL workbench is a graphical application that lets us manage data and perform administrative tasks on MySQL databases. In this tutorial, we will see how to install the program on…
How to Recover from mysql log read failure
If you deal with MySQL master/slaves a lot you may run into the following error. Relay log read failure: Could not parse relay log event entry. To fix this you…
How to export/import MySQL database with correct character set on Linux?
To Export/Import MySQL database with correct character set on Linux export your database with the correct character set is important to avoid any kind of problems with data that has…
How to Install MySQL on Ubuntu 18.04
In this post, we will learn how to install MySQL on Ubuntu 18.04 Before proceeding, the user must have sudo privileges using which you are logged in. Installing MySQL 1)…