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.

skip-name-resolve: how to disable MySQL DNS lookups

mysql tips and tricks

MySQL Reverse DNS lookups are often the cause of long delay and slow MySQL performance when running certain SQL queries. Sometimes it takes hours or days to detect that the problem in your slow SQL connection times is indeed caused by the skip-name-resolve variable located inside your MySQL configuration file. This tutorial applies to the following scenarios: Disabling…

Read More »

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 »