MySQL
To use MySQL, download the package from
http://www.mysql.org and install
it. I’ve got a mysql user with
access to the scripts, and the /usr/local/mysql/bin directory in that
user’s path. I’ve also set my root
MySQL user’s password to a non-empty password; you
should do this too, with the command mysqladmin
-u
root
password
[new password]. You
can then create the Forethought database with the following command:
[localhost:~] mysql% mysqladmin -u root -p create forethought Enter password:
You won’t get any visible output, but
don’t be concerned; this does create the database.
You’re now ready to connect to the database and run
the SQL scripts. Use the mysql command for this,
as shown:
[localhost:~] mysql% mysql -u root -p forethought Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> source database_schema_users.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 1 row affected (0.01 sec) mysql> source database_schema_accounts.sql Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql> exit Bye
In the same manner, you can use the source command to execute the keys script, the data types script, and the script that drops tables. ...