From the blog
Grep case sensitive examples and usage
grep is one of the most useful tools to find text characters, words and phrases inside your Linux box. Today we will show you how the correct usage of grep case sensitive parameter to find the exact information you need. Let’s suppose you have two words inside a text file: Hello and hello. If you run a normal…
Read More »eth0 NIC Link is Down error on Linux
This error has happened to me a few times in the past years. The network suddenly gets frozen and then it cames back after a few seconds, on other times it gets frozen and the only way to work remotely on the server is to reboot the box. This is the exact error message I get: kernel: e1000e:…
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 »How to recover email box from a cPanel full backup
Q: How can you recover an email box and all its stored emails from a cPanel backup? A: You can recover an email box from a cPanel full backup extracting and copying the email files. Let’s see how to find out where are our emails stored inside a cPanel full backup, and how to copy that to your…
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 »