Skip to Main Content
Building Java Enterprise Applications
book

Building Java Enterprise Applications

by Brett McLaughlin
March 2002
Intermediate to advanced content levelIntermediate to advanced
320 pages
8h 58m
English
O'Reilly Media, Inc.
Content preview from Building Java Enterprise Applications

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. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Enterprise Web Programming with Java

Enterprise Web Programming with Java

O'Reilly Media, Inc.
Modernizing Enterprise Java

Modernizing Enterprise Java

Markus Eisele, Natale Vinto

Publisher Resources

ISBN: 0596001231Supplemental ContentCatalog PageErrata