MySQLTips

From Linusphere
Revision as of 16:36, 17 December 2016 by TaejoonKwon (talk | contribs) (Created page with "== Users == > CREATE > GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’; > REVOKE [type of permission] ON [database name].[tabl...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Users

> CREATE
> GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;
> REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;
> FLUSH PRIVILEGES;