Changing phpmyadmin root password

Question

I'm trying to figure out how to change the root password for phpmyadmin. I've tried doing this a few times using this:

$ mysql -u root -p
use mysql;
update user set password=PASSWORD("NEWPASSWORD") where User='root'

But then when I go to login using the new password or even the old password, I'm denied access. Any help is appreciated!

score 2 · Answer 1 · edited Feb 16 '17 at 16:57

2

I was able to do this by instead of doing update
update user set password=PASSWORD("newpassword") where User='root'
but using
set password = password ("newpassword");
flush privileges //optional
quit

edited Feb 16 '17 at 16:57

YaSh Chaudhary

215
2
8

answered Jul 11 '10 at 05:46

user48060

71
2

Could you please accept your own answer here? Thanks! – splattne Sep 09 '10 at 06:32

score 0 · Answer 2 · answered Sep 08 '10 at 23:49

Because really what you have to change is the root password of MySQL.

As a side note, I suggest you to block root from logging on phpmyadmin and only login to it using specific users with access to specific databases, unless it is strictly necessary to have root access (like, there's no console access to the DB server).

If really necessary, at least run phpmyadmin over SSL, since passing the MySQL root password over clear text connection is not very wise.

not able to block root from logging as per your suggested article. — YaSh Chaudhary, Feb 16 '17 at 13:59

Changing phpmyadmin root password

2 Answers2