Sunday, June 3, 2012

Chaning MySQL user password


1) login to MySQL server, type following command at shell prompt to login as root
$ mysql -u root -p

2) Use mysql database (type command at mysq prompt, do not include string "mysql>"):
 use mysql;

3) Change password for user saji:
update user set password=PASSWORD("mypass") where user='saji';

No comments: