MySQLメモ

パスワード変更

SET PASSWORD FOR 'username'@'hostname' = PASSWORD('password');

ユーザー削除

DROP USER 'username'@'hostname';

ユーザー情報取得 mysql.userからSELECTする

> 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)