Disclaimer:
This post is for educational purposes only and no responsibility will be taken if you execute any of the commands. You mess it, you fix it!
Replacing a password for a user on MySQL can be done in at least four ways. Three ways at least.
1. set password for ‘user’@'host’=password(‘abc’);
2. grant usage on *.* to ‘user’@'host’ identified by ‘abc’;
3. update mysql.user set password=password(‘abc’) where user=’user’ and host=’host’;
mysql Wed Mar 9 14:27:17 2011 > set password for 'dc'@'%' = password('d');
Query OK, 0 rows affected (0.00 sec)
mysql Wed Mar 9 14:27:39 2011 > show grants for 'dc'@'%';
+---------------------------------------------------------------------------------------------------+
| Grants for dc@% | …[Read more]