PHPMyAdmin

[GPNHosting]

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?

 

[ProWebUK]

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

 

[GPNHosting]

ERROR 1045: Access denied for user:

 

[DirectAdmin Support]

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

 

[XenoHosting]

how do you reset the passwerd in shell

 

[DirectAdmin Support]

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

 

[XenoHosting]

well how do i do it in da then

 

[DirectAdmin Support]

Hello,

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

John

 

[S2S-Robert]

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.

 

[DirectAdmin Support]

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:

GRANT ALL PRIVILEGES ON username_dbname.* TO username@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

John