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/15] How to Create a MySQL Database
- [2016/05/15] Manage Remote MySQL Server with Local ...
- [2016/05/20] Install Percona MySQL Server on Debian