1
GRANT ALL ON test.* TO mysqltest_1@'127.0.0.1/255.255.255.255';
2
SHOW GRANTS FOR mysqltest_1@'127.0.0.1/255.255.255.255';
3
Grants for mysqltest_1@127.0.0.1/255.255.255.255
4
GRANT USAGE ON *.* TO 'mysqltest_1'@'127.0.0.1/255.255.255.255'
5
GRANT ALL PRIVILEGES ON `test`.* TO 'mysqltest_1'@'127.0.0.1/255.255.255.255'
6
REVOKE ALL ON test.* FROM mysqltest_1@'127.0.0.1/255.255.255.255';
7
DROP USER mysqltest_1@'127.0.0.1/255.255.255.255';
12
Id User Host db Command Time State Info
13
<id> root <host> test <command> <time> <state> <info>
14
<id> root <host> test <command> <time> <state> <info>