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)
Discover more from thekeesh.com
Subscribe to get the latest posts sent to your email.