What are the set of statements that would create the above rules?
Code: Select all
grant select on *.* to mysql.* to somebody@localhost
grant select on *.* to information_schema.* to somebody@localhost
OR
if offered,
grant all on *.* to somebody@localhost
then we can,
revoke grant option on *.* to somebody@localhost
revoke drop, delete, update, insert on mysql.* from somebody@localhost
revoke drop, delete, update, insert on information_schema.* from somebody@localhost
but still I do not know how to allow the user to create databasesanybody know the command to do it?