Users

From MyWiki
Revision as of 13:51, 18 September 2014 by George2 (Talk | contribs)

Jump to: navigation, search
grant ALL on <database>. to '<username>'@'<hostname>' identified by '<password>'
GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;
REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;