Posted on

Create MySQL Database and Give User Permissions

I always find myself needing to look up this exact syntax.

mysql> create database MY_DATABASE character set utf8;
Query OK, 1 row affected (0.04 sec)

mysql> grant all privileges on MY_DATABASE.* to 'MY_USERNAME'@'localhost' identified by 'MY_PASSWORD';
Query OK, 0 rows affected (0.06 sec)

Leave a Reply