So basically this is what I did:
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set password=PASSWORD("~)<iXyyj<w!,s!\yZ%]YN#m;d") where User='root';
Query OK, 2 rows affected (0.01 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
And now I can't access using that password. What did I do wrong? maybe the password isn't supposed to have special characters or something?
PS: centos 6.5
*C451CBEFADBDA21A0BA18DCDAE886B3A422EA0C4
– Russell Uhl Aug 1 '14 at 20:46