Changing the password for a phpmyadmin database?

Can anyone, in plain noob lingo, please explain how to change the password for a phpmyadmin database please ?

Any help appreciated.

Dez.

Do you know the current password?

Once you log in it should say change password on the right-hand side.

I don’t see that in my version.

I don’t know much about SQL, but I successfully changed my password via phpMyAdmin by doing this:

In phpMyAdmin home page, click on DB name.

Click on the SQL tab.

In the large textarea, type (with words in red altered to suit, as shown below):

GRANT ALL PRIVILEGES ON dbname.* TO username@localhost IDENTIFIED BY ‘password’ WITH GRANT OPTION

dbname = the data base name
username = the username you have chosen
password = the password you want to use

Click Go.

As I say, this worked nicely while I was working on a local installation—but I didn’t have any critacal data I couldn’t afford to lose. It might be worth googling a bit to get a second opinion, or wait for more replies. :slight_smile:

Actually, Googled it myself and found this, which is probably better:

SET PASSWORD FOR 'username'@'localhost' = PASSWORD('newpassword');

For information on the SET PASSWORD command see: dev.mysql.com/doc/refman/5.0/en/set-password.html