Category Archives: Databases

#1045 Cannot log in to the MySQL server phpMyAdmin error

#1045 Cannot log in to the MySQL server, this was the error I got today on a phpMyAdmin installation inside a cPanel server while trying to access the application. phpMyAdmin is one of the best tools to handle your MySQL databases and tables inside cPanel servers. However, sometimes we get strange errors while trying to use it. Today we will… Read more »

Unable to establish a PHP session PHPMyAdmin error

Access Denied Unable to establish a PHP session. If you believe that this is in error or inadvertent, contact your system administrator and ask them to review your server settings. That was the error seen on a phpmyadmin installation on one of my customer servers. It’s related to the phpMyAdmin sessions, which need to be written inside the /tmp directory… Read more »

How can I access phpMyAdmin without cPanel login?

A common question by many cPanel end users is: How can I access the phpmyadmin interface without the cPanel credentials? In fact, this has been a feature request by cPanel users, but it has been declined by cPanel development team. However, there is still a workaround to access phpmyadmin without cPanel username and password. On this tutorial, we will show… Read more »

mysqldump: Got error: 1044: Access denied for user ‘user’@’localhost’ to database ‘database_name’ when using LOCK TABLES

Today I was generating mysql dumps over a few MYSQL databases using the common mysqldump command, and got the following error: mysqldump: Got error: 1044: Access denied for user ‘user’@’localhost’ to database ‘database_name’ when using LOCK TABLES The command was a simple mysqldump: mysqldump -u user -p DBNAME > backup.sql What causes mysqldump: 1044 Access denied error ? mysqldump is… Read more »

MySQL Configuration File Sections Explained

MySQL configuration file sections are something often overlooked by developers and sysadmins, and not everybody takes the time to read and understand what are the my.cnf file sections. On this post we will explain what are the most important mysql configuration sections inside the /etc/my.cnf file. Common MySQL Configuration File Sections On a normal MySQL configuration you will find a configuration… Read more »

How can I change the default MYSQL time zone?

Is there any way to change the default time zone in MySQL? That was the question made from one of my customers. And the answer is simple, yes, the MySQL time zone can be changed without any problems using the command line. This change will affect all your MySQL databases, and can not be applied to only one database, it’s… Read more »

How to edit MySQL my.cnf file on cPanel

When you have your first dedicated server, cloud or vps box, sometimes you need to tweak the server performance to gain speed for your web applications. One of the most common areas you’ll be forced to tweak is MYSQL Configuration.  Today you’ll learn how to edit MySQL my.cnf file on cPanel. How can I edit MySQL my.cnf file on cPanel servers?… Read more »