PHPMyAdmin

G

GPNHosting

Verified User
Joined
Jan 18, 2004
Messages
12
When a user attempts to use phpMyAdmin they are asked their login information. I attempted to use this to login but it says that the username and password do not exist. Any ways on fixing this?
 
In shell:

mysql -u username -p

If you can login there phpmyadmin should work also... if that doesnt work the mysql user doesnt exist (check in DA that it exists also)

Chris
 
Hello,

You'll have to double check your username and password then. If in doubt, reset the password.

sample:

mysql -u username_bob -p
Password: secret

John
 
Hello,

To set a mysql password in the shell, you have to login into mysql either as root, or da_admin, and then run:

use mysql;
UPDATE user SET password=PASSWORD('newpass') WHERE user='username';
FLUSH PRIVILEGES;

It's much easier to do it via DA :)

John
 
Hello,

User Panel -> Mysql Database -> db_name -> modify_password -> enter new password twice -> click Save.

John
 
and how do you change it for the main mysql / CP account? The user is able to login using the simple database username, but not using the general username which gives access to all the underlying databases.

I tried changing his control panel password, but that doesn't seem to fix the problem.
 
Hmm.. it should...

perhaps go into phpmyadmin as da_admin, go to the mysql database, db table, and make sure that there exists the username on that database.. if not, you may have to run:

Code: 
GRANT ALL PRIVILEGES ON username_dbname.* TO username@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
John
 
You must log in or register to reply here.
Back
Top