Whoocus

■ユーザ確認

SELCET user, password, host FROM mysql.user;

■ユーザ追加

GRANT ALL ON db_name.* TO hoge@localhost IDENTIFIED BY '*****';
GRANT ALL ON db_name.* TO hoge@'192.168.0.%' IDENTIFIED BY '*****';
GRANT ALL ON db_name.* TO hoge@'192.168.0.6' IDENTIFIED BY '*****';

■権限追加

GRANT ALL ON db_name.* TO hoge@'192.168.0.%' IDENTIFIED BY '*****';

■ユーザ削除

REVOKE ALL ON hoge.* FROM db_name@hostname;
DELETE FROM mysql.user WHERE USER LIKE 'hoge' AND HOST LIKE 'localhost';

REVOKE ALL ON hoge.* FROM db_name@hostname;
DELETE FROM mysql.user WHERE USER LIKE 'hoge' AND HOST LIKE 'hostname';

REVOKE ALL ON mt.* FROM mt@192.168.0.6;
DELETE FROM mysql.user WHERE USER LIKE 'hoge' AND HOST LIKE '192.168.0.6';

■リフレッシュ

FLUSH PRIVILEGES;