Installing a MySQL database for the blueprint design server

The blueprint design server requires a database, and you can use a MySQL database.

About this task

For evaluation purposes, the blueprint design server installer can install an Apache Derby database, but for a production system, you can use a MySQL database. You can install the database on the same computer as the blueprint design server or on a different computer.

Note: If you installed an engine instead of extending an existing engine and you install the engine and the blueprint design server on the same computer, use the database that the engine uses. See Adding the blueprint design server database to the engine MySQL database.

Procedure

Install and start MySQL.
1. Install the database server. For example, run the following command:
```
yum install mysql mysql-server
```
2. Set the database to run automatically:
```
chkconfig mysqld on
```
3. Start the database:
```
/etc/init.d/mysqld start
```
Log in to the database server as a user with table-creation privileges. For example, if you installed MySQL as the root user, run this command from the command line:
```
mysql -u root
```
The command line shows a prompt that looks like this example:
```
mysql>
```
Create a user for the blueprint design server to use and assign the user a password, as in the following example command. This example creates a user that is named ibm_ucdp with the password as a ibm_ucdp.
```
CREATE USER 'ibm_ucdp'@'localhost' IDENTIFIED BY 'password';
```
Remember this user name and password because you must have them when you install the blueprint design server.
Create a database for the blueprint design server, as in the following example command:
```
CREATE DATABASE ibm_ucdp;
```

Grant permissions for the user to work with the database:

GRANT ALL ON ibm_ucdp.* TO 'ibm_ucdp'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

Type quit to exit the MySQL command line.

What to do next

Install the blueprint design server and specify the connection information for this database. If you used the example commands above, the database connection URL is jdbc:mysql://hostname:3306/ibm_ucdp , where hostname is the host name or IP address of the database server. The user name and password for the database in these examples is ibm_ucdp and password. See Installing the blueprint design server.

Feedback