====== MySQLメモ ======

パスワード変更
<code>
SET PASSWORD FOR 'username'@'hostname' = PASSWORD('password');
</code>

ユーザー削除
<code>
DROP USER 'username'@'hostname';
</code>

ユーザー情報取得
mysql.userからSELECTする
<code>
> SELECT user,host,password FROM mysql.user;
+------------+-----------+-------------------------------------------+
| user       | host      | password                                  |
+------------+-----------+-------------------------------------------+
| root       | localhost | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| root       | 127.0.0.1 | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| root       | ::1       | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
+------------+-----------+-------------------------------------------+
11 rows in set (0.001 sec)
</code>