Difference between revisions of "MySQL"
From Useful Things
(Created page with "= MySQL = == Adding a user == <syntaxhighlight lang="mysql"> grant all privileges on {database_name}.* to {database_user}@'%' identified by 'their_password'; </syntaxhighlight...") |
|||
| Line 1: | Line 1: | ||
| − | + | = 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'; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | + | = Revoking privileges = | |
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
revoke usage on {databse_name}.* from 'user'@'%'; | revoke usage on {databse_name}.* from 'user'@'%'; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | + | = Removing a user entirely = | |
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
drop user {user_name}@'%'; | drop user {user_name}@'%'; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 02:13, 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}@'%';