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.

How to setup a Remote MySQL Database Connection

mysql tips and tricks

90% of the times you connect to a MySQL database it is done by using “localhost” as the host inside the connection settings in your PHP files, as most of you host the files and the database on the same server.  However, especially in high traffic websites, a remote MySQL database is needed. In other occasions, you will need…

Read More »

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 »