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

• [2016/05/15] Disable MySQL Performance Schema
• [2016/09/28] Quickly Rename MySQL Database
• [2016/05/15] Increase MySQL Max Connections Limit
• [2016/05/15] How to Recover MySQL Root Password
• [2016/05/15] Mysqli() Headers Client Library Minor ...
• [2016/05/20] Install Percona MySQL Server on Debian
• [2016/05/15] Manage Remote MySQL Server with Local ...
• [2016/05/15] How to Create a MySQL Database