Difference between revisions of "MySQL"
From Useful Things
| Line 7: | Line 7: | ||
= Revoking privileges = | = Revoking privileges = | ||
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
| − | revoke usage on {databse_name}.* from | + | revoke usage on {databse_name}.* from {database_user}@'%'; |
</syntaxhighlight> | </syntaxhighlight> | ||
<br /> | <br /> | ||
Revision as of 02:22, 25 June 2014
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 entirely
drop user {user_name}@'%';