Home » Databases

MYSQL Tutorials

cPanelTips MYSQL Tutorials are the most easy to use and well explained MySQL tutorials around. You will find simple and practical step by step guides based in our sysadmin and developer experience.  Let us teach you how to tweak your MYSQL Server Security and Performance.

How to find MySQL root password on MySQL 5.7

Where is the MySQL 5.7 root password? That was the question I made yesterday when I was going to connect to MySQL 5.7 console. Here is what I found about this simple question for MySQL 5.7 users. Find…

Read More »

MYSQL error (1547): Column count of mysql.proc is wrong

MySQL Problem: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted. That was the error seen on the MYSQL shell when I was about to generate a MySQL dump . It simplydenied…

Read More »

ERROR 1805 (HY000): Column count of mysql.user is wrong. Table is probably corrupted

On the nixcp.com server the other day I found something weird when I was about to grant MySQL privileges to a new MySQL user. When I ran the SQL query, an error appeared on the screen: ERROR 1805 (HY000):…

Read More »

Could not increase number of max_open_files to more than 12000

Exploring the MySQL error log file on a cPanel server I found this odd message: Could not increase number of max_open_files to more than 12000.  This was happening on a CentOS 7 + cPanel + CloudLInux server. What is…

Read More »

Speedup MySQL InnoDB Shutdown by Flushing Dirty Pages

Days ago one of our customers with a very large InnoDB database was having a strange error while trying to restart MySQL server. So our tech team started investigating and found it was caused due to the very big…

Read More »

How to Generate a Full MYSQL Backup using MySQLDump

On this post we will explore the best way to generate a full MYSQL backup of all your databases inside a Linux server. This is useful for most Linux distributions such as CentOS/RHEL, Ubuntu/Debian, and of course it’s…

Read More »

Install MongoDB on cPanel + CentOS Linux

Question: how can I install MongoDB on cPanel servers using CentOS? Answer: MongoDB can be installed using the classic RPM packages. On this post we will explore how to install MongoDB on cPanel servers using CentOS operating system….

Read More »