Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

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)