How to change a normal user's password in mysql

Advertisements

Suppose you want to change the user john's password to abc123#

mysql -u root -p
Give password.

Change databse
mysql> use mysql

mysql> update user set password=PASSWORD("abc123#") where User='john';

Flush privileges if needed
mysql> flush privileges;

quit
mqsql>\q

Now login as john
mysql -u john -pabc123#

Thats it. Now you should be logined as john.

To check it, run
mysql>select user();