Get Free Linux Server Security, Performance & Troubleshooting Tips

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.

Linux PostgreSQL Restart Command

postgresql management commands on linux

PostgreSQL is an open source object-relational multi-platform database management system and one of the most popular alternatives to MYSQL. It is available on Windows, MacOS, Linux and Unix based systems. Today we will show you how to restart postgresql on Linux, you will also learn how to stop, start and get the full pgsql status from the Linux…

Read More »

Check MySQL Server Uptime | Know MySQL uptime from Linux terminal

Question: how can I get mysql server uptime from the Linux command line? Answer: there are a few simple ways to check mysql server uptime from the Linux terminal, wheter you are on a vps, cloud or dedicated box, the methods are the same and they will work on most MySQL versions. 3 ways to Check MySQL server…

Read More »

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 MySQL 5.7 root password Unlike previous versions, by default MySQL 5.7 automatically creates a temporary root password. And if you…

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 me showing me that error, I couldn’t ran any SQL operation at all. This happened when I was migrating a…

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): Column count of mysql.user is wrong. Expected 43, found 42. The table is probably corrupted   This was the exact…

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 MySQL open files limit directive? In simple words: open_files_limit directive from MYSQL is the maximum # of files allowed to…

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 size of the InnoDB database and the dirty pages. What are dirty pages after all? First things first: having dirty…

Read More »