Thursday, December 2, 2010

MYSQL USER MANAGER

Create user:
create user 'username'@'hostname' identified by 'password';

Delete mysql user:
drop user 'username'@'hostname';

Grant privileges to user:
grant all privileges on database.tables to 'username'@'hostname' identified by 'password';

Revoke privileges from user:
REVOKE
priv_type [(column_list)]
[, priv_type [(column_list)]] ...
ON [object_type] priv_level
FROM user [, user] ...

No comments:

Post a Comment