■ユーザ確認
[code]
SELCET user, password, host FROM mysql.user;
[/code]
■ユーザ追加
[code]
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 ‘*****’;
[/code]
■権限追加
[code]
GRANT ALL ON db_name.* TO hoge@’192.168.0.%’ IDENTIFIED BY ‘*****’;
[/code]
■ユーザ削除
[code]
REVOKE ALL ON hoge.* FROM db_name@hostname;
DELETE FROM mysql.user WHERE USER LIKE ‘hoge’ AND HOST LIKE ‘localhost’;
[/code]
[code]
REVOKE ALL ON hoge.* FROM db_name@hostname;
DELETE FROM mysql.user WHERE USER LIKE ‘hoge’ AND HOST LIKE ‘hostname’;
[/code]
[code]
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’;
[/code]
■リフレッシュ
[code]
FLUSH PRIVILEGES;
[/code]