dez — 2010-03-27T08:36:33-04:00 — #1
Can anyone, in plain noob lingo, please explain how to change the password for a phpmyadmin database please ?
Any help appreciated.
rguy84 — 2010-03-27T23:05:38-04:00 — #2
Do you know the current password?
Once you log in it should say change password on the right-hand side.
ralphm — 2010-03-28T09:25:55-04:00 — #3
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
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.
ralphm — 2010-03-28T10:09:53-04:00 — #4
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