MKの日記： mysql パスワード変更

mysql で，root のpassword 変更で嵌ったのでmemo

mysql> set password for root=PASSWORD('hoge');
ERROR 1133 (42000): Can't find any matching row in the user table

mysql> SET PASSWORD FOR root@localhost=PASSWORD('hoge');
Query OK, 0 rows affected (0.05 sec)

mysql も勉強しなきゃなぁ…．