Tag: grant

Show privileges for mysql users

(source) To show one users privilges in mysql: Read More »
By halfgaar, 9 years ago, on September 30, 2010, at 11:09 | Comments closed

Creating new MySQL database and user

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'; Read More »
By halfgaar, 10 years ago, on March 16, 2010, at 12:03 | 1 comment