Difference between revisions of "MySQL"
From Useful Things
| Line 5: | Line 5: | ||
grant all privileges on {database_name}.* to {database_user}@'%' identified by 'their_password'; | grant all privileges on {database_name}.* to {database_user}@'%' identified by 'their_password'; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | |||
== Revoking privileges == | == Revoking privileges == | ||
| Line 11: | Line 10: | ||
revoke usage on {databse_name}.* from {database_user}@'%'; | revoke usage on {databse_name}.* from {database_user}@'%'; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | |||
== Removing a user == | == Removing a user == | ||
Revision as of 05:14, 25 June 2014
User management
Adding a user
grant all privileges on {database_name}.* to {database_user}@'%' identified by 'their_password';Revoking privileges
revoke usage on {databse_name}.* from {database_user}@'%';Removing a user
drop user {database_user}@'%';