MySQL

From Useful Things
Revision as of 05:14, 25 June 2014 by Milosivanovic (talk | contribs)
Jump to: navigation, search

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}@'%';