Difference between revisions of "MySQL"
From Useful Things
| Line 3: | Line 3: | ||
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> | ||
| + | <br /> | ||
= Revoking privileges = | = Revoking privileges = | ||
| Line 8: | Line 9: | ||
revoke usage on {databse_name}.* from 'user'@'%'; | revoke usage on {databse_name}.* from 'user'@'%'; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| + | <br /> | ||
= Removing a user entirely = | = Removing a user entirely = | ||
Revision as of 02:15, 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 'user'@'%';
Removing a user entirely
drop user {user_name}@'%';