Datareign

Provided that the mysqld service is running, creating a database is simply a matter of logging in as a user with sufficient privileges…

 $> mysql -U root -P
 Enter password: xxxxxxxxxxxx
  
 mysql> create database customers;
 Query OK, 1 row affected (0.01 sec)

Then create a database owner and give it full privileges:

 mysql> create user custowner identified by 'c8st0m3r';
 Query OK, 0 rows affected (0.01 sec)
 
 mysql> use customers;
 Database changed
 mysql> grant all on customers to 'custowner';
 Query OK, 0 rows affected (0.17 sec)
 
 mysql> 
 
Last modified: 2009/01/23 15:29