Monday, October 6, 2008

Create Database

I'll need to remember this information to set up MySQL in production.
mysql> create database qotd_prod;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on qotd_prod.*
-> to 'prod_user'@'localhost'
-> identified by 'password';
Query OK, 0 rows affected (0.05 sec)

No comments:

Post a Comment