How to Change MySQL User Password

Change MySQL password with SQL commands:

update user set password=PASSWORD("YOUR_NEW_PASS") where user='andry';
flush privileges;

Change MySQL password with MySQLAdmin:

mysqladmin -u andry -p'oldpass' password 'newpass'

More Related Posts