版主啊... 不行啊...drop user monty@localhost; grant all privileges on test.* to [email protected] identified by '123456' with grant option; select * from mysql.host;
The host table is not affected by the GRANT or REVOKE statements, so it is unused in most MySQL installations. If you modify it directly, you can use it for some specialized purposes, such as to maintain a list of secure servers on the local network that are granted all privileges. 只能手工 insert 了
2) GRANT 。 ON db1.*
grant all privileges on test.* to [email protected]
identified by '123456' with grant option;
select * from mysql.host;
只能手工 insert 了