Difference between revisions of "MySQL"
From Useful Things
| Line 1: | Line 1: | ||
| − | = Adding a user = | + | = User management = |
| + | |||
| + | == Adding a user == | ||
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
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'; | ||
| Line 5: | Line 7: | ||
<br /> | <br /> | ||
| − | = Revoking privileges = | + | == Revoking privileges == |
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
revoke usage on {databse_name}.* from {database_user}@'%'; | revoke usage on {databse_name}.* from {database_user}@'%'; | ||
| Line 11: | Line 13: | ||
<br /> | <br /> | ||
| − | = Removing a user | + | == Removing a user == |
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
drop user {database_user}@'%'; | drop user {database_user}@'%'; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 05:11, 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}@'%';