아미(아름다운미소)

grant all privileges on dbname.table to userid@host identified by 'password';

grant all privileges on *.* to userid@host identified by 'password';

grant all privileges on *.* to userid@'%' identified by 'password';

flush privileges;

revoke all on dbname.table from userid@host

show grants for userid@host