Tag: grant

Show privileges for mysql users

September 30, 2010 / halfgaar

(source) To show one users privilges in mysql:

SHOW GRANTS FOR 'luser'@'localhost';

To list current users grants:

SHOW GRANTS;

Show all users:

select user,password,host from mysql.user;

March 16, 2010 / halfgaar

I often need to make a MySQL database and a user that can do anything in it:

create database bla character set utf8 collate = utf8_general_ci;
use bla
grant all on bla.* to 'jack'@'localhost' identified by 'password';

To drop a user:

drop user ‘jack'@'localhost’;