MySQLTips

From Linusphere
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;