SQL: Create a user that has only access to one database

Revision: 24973

at March 17, 2010 04:31 by manuelstofer

Initial Code

CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON `database` . * TO 'username'@'%';
FLUSH PRIVILEGES;

Initial URL

Initial Description

creates a user that has only access to one database, from any host

Initial Title

SQL: Create a user that has only access to one database

Initial Tags

mysql, sql, user

Initial Language

SQL