ユーザー削除
権限の確認
mysql> show grants for testusr@localhost;
+-------------------------------------------------------------------------------------------------------------------------+
| Grants for testusr@localhost |
+-------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'testusr'@'localhost' IDENTIFIED BY PASSWORD '*21BD2B1704A9F009E38F69DB52C577CC0110050D' |
+-------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
※権限があることを確認
権限の削除
mysql> revoke ALL PRIVILEGES on *.* from testusr@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for testusr@localhost;
+----------------------------------------------------------------------------------------------------------------+
| Grants for testusr@localhost |
+----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'testusr'@'localhost' IDENTIFIED BY PASSWORD '*21BD2B1704A9F009E38F69DB52C577CC0110050D' |
+----------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
※権限がなくなったことを確認
ユーザーの削除(DROP USER <ユーザー名>[@<ホスト名>])
mysql> drop user testusr@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT host,user,password FROM mysql.user;
+---------------+---------+-------------------------------------------+
| host | user | password |
+---------------+---------+-------------------------------------------+
| localhost | root | *FAAFFE644E901CFAFAEC7562415E5FAEC243B8B2 |
| | testdb | *3DED544079AC3FB1E5407B3BAF4DACB6805C56EF |
| % | testdb | *3DED544079AC3FB1E5407B3BAF4DACB6805C56EF |
| % | dbadmin | *0380CF134224D1081A3E80CD18B031054A828A93 |
| % | ts_user | *98BE1C0DB118D928DDEFCA539ACE3AEC76FBC00B |
| 172.16.10.102 | ts_user | *98BE1C0DB118D928DDEFCA539ACE3AEC76FBC00B |
| localhost | testdb | *3DED544079AC3FB1E5407B3BAF4DACB6805C56EF |
| 172.16.10.102 | testdb | *3DED544079AC3FB1E5407B3BAF4DACB6805C56EF |
+---------------+---------+-------------------------------------------+
8 rows in set (0.00 sec)
mysql>
※ホスト、ユーザーが存在しないことを確認
最終更新：2010年06月22日 12:07
