LinuxQuestions.org - phpMyAdmin not allowing logins from users setup to specific databases.

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - phpMyAdmin not allowing logins from users setup to specific databases. (https://www.linuxquestions.org/questions/linux-newbie-8/phpmyadmin-not-allowing-logins-from-users-setup-to-specific-databases-939672/)

phpMyAdmin not allowing logins from users setup to specific databases.

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.

MySQL is installed correctly, it lets me login with root perfectly fine, cookie auth is on, blowfish secret set, etc, etc.

I setup a user to test it via commandline.

Originally the user 'jeffrey' had the host as any host '%', but when changing it to localhost it seemed to of worked, is it possible that I can allow remote logins?

Quote:

[root@vm phpmyadmin]# mysql -u jeffrey -pabc
ERROR 1045 (28000): Access denied for user 'jeffrey'@'localhost' (using password: YES)
[root@vm phpmyadmin]# mysql -u jeffrey -p
Enter password:
ERROR 1045 (28000): Access denied for user 'jeffrey'@'localhost' (using password: YES)
[root@vm phpmyadmin]# mysql -u jeffrey -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 245
Server version: 5.5.22-cll MySQL Community Server (GPL) by Atomicorp

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

It would be nice to list your solution here so that other members coming here with same issue can find it outright. Also mark your thread as SOLVED using thread tools.

For some reason I needed to create two users for the one DB, one with any hostname and one with the hostname as localhost.