No sure if it correct for latest WHM/cPanel servers. It’s a very old post and for cPanel servers. How to access PhpMyAdmin without cpanel password? Make sure that “Allow MySQL password change” has been enabled while you are changing the password. Reset the cPanel password for the user that you are facing this problem. If your MySQL server is up and again you are receiving the error as #1045 Cannot log in to the MySQL server then, you can continue reading this.Ģ. In this way you can troubleshoot why the MySQL service is down. If all this cases are fine, then you need to check the MySQL logs in the file /var/lib/mysql/hostname.err or you can check in /var/log/mysqld.log. For an initial testing, you can check #df -hĪlso, check the permission of /tmp and see if you can touch a file in /tmp. In that case, you can try running #/etc/init.d/mysqld startĮven after starting MySQL, if it’s not started then you need to investigate the root cause why the MySQL service is down. If not, then your MySQL service is stopped for any reason. If you are able to log into the MySQL prompt then we can conclude that your MySQL server is up and running. If you are getting the expected output, then try to log in the MySQL prompt by running # mysql -u root -p You can check this by running the following commands: # /etc/init.d/mysqld status Please see the error details below: # 1045 Cannot log in to the MySQL serverġ. This is an error that I received while accessing PHPMyAdmin via cPanel. ![]() This article will help you to access databases of cPanel users’ without accessing the cPanel account.Ĭonsider the scenario, you’ve a cPanel account and you want to share the details of a database (DB) with one of your we site developers and actually you do not want to share the cPanel credentials. Accessing PhpMyAdmin without cPanel login? PhpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows executing SQL statements or managing users and permissions. Post Views: 29,936 PHPMyAdmin Error #1045 Cannot log in to the MySQL server.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |