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