Iteration A1 (Create the Database)

プロジェクト作成済みなので DB から

debian では default な MySQL の root パスワードは空。

~/depot$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 24 to server version: 4.0.24_Debian-10-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database depot_development ;
Query OK, 1 row affected (0.21 sec)

mysql> create database depot_test ;
Query OK, 1 row affected (0.00 sec)

mysql> create database depot_production ;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on depot_development.* to 'dave@localhost' ;
Query OK, 0 rows affected (0.70 sec)

mysql> grant all on depot_test.* to 'dave@localhost' ;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on depot_production.* to 'prod@localhost' identified by  'wibble' ;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

~/depot$