I recently installed phpMyAdmin with MySQL, it works fine, allows the root to login via the website, but when I attempt to create users and give assign them to a database, it gives me the error "#1045 Cannot log in to the MySQL server". This server is running on CentOS 5.8.
1 Answer
Ensure the credentials in the phpMyAdmin configuration are correct and that it is pointed at the correct server. You may also check your mysql logs (possibly in the system logger but generally /var/log/mysql/mysqld.err and /var/log/mysql/mysqld.log) to see what happens when you try to do anything in phpMyAdmin.
Remember that phpMyAdmin's login is separate from the mysql login.
- I deleted the mysqld.log and then tried to login again, nothing changed, still getting #1045 Cannot log in to the MySQL servernd8ad– nd8ad2012-04-13 08:49:39 +00:00Commented Apr 13, 2012 at 8:49
- 1I didn't mean that deleting the logs would help; I meant that more information on the error would be contained in them.Falcon Momot– Falcon Momot2013-06-26 05:00:18 +00:00Commented Jun 26, 2013 at 5:00