PHPMyAdmin Access denied for user X @ localhost

When you can’t log in to PHPMyAdmin from within cPanel it’s mainly one of two reasons: When you reset the password for that user, MySQL password wasn’t changed user has a custom .my.cnf file with defined logins for mysql Step 1...

Move email accounts from one cPanel account to another

Moving email accounts along with all emails from one cPanel to another can be done in two ways: IMAPSync – you need access to a terminal and passwords for email accountsFTP (File Manager) – you need access to FTP or cPanel File Manager...

Flush nscd DNS cache

name service cache daemon (nscd) cache is persistent by default on CentOS 7, to flush it, you need to run: nscd -i hosts -i stands for invalidate. You can also check if nscd‘s cache is persistent by running nscd -g nscd caches several other types of...

Create a new MySQL user dedicated to backups

I recommend setting a new MySQL user for backups and never using the root MySQL account to do backups. Step 1. Log on to MySQL as root: mysql -u root -p Step 2. Create a new user and grant all necessary permissions: CREATE USER...

Complete guide to Git Version Control in cPanel

On cPanel Git can be used in two ways: clone a remote repository (e.g. from GitHub) to cPanelcreate a repository on cPanel and use it in a remote location (e.g. your pc) Here I will cover both ways and highlight some important steps that are not...

Change MySQL data directory in PHPMyAdmin

In a recent article, I discussed many methods for removing the large ibdata file, one of which involves transferring the MySQL data directory to a different partition. However, if you do so, you must also inform PHPMyAdmin of the location of the...