mysql

November 11, 2020

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 […]
June 13, 2020

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 […]
May 3, 2020

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 […]
April 10, 2020

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 […]
April 1, 2020

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, […]
March 28, 2020

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 […]
June 30, 2019

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. […]
June 30, 2019

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 […]
June 14, 2019

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 […]