Download and Install MySQL Server

MySQL is the database system which will be used in this integration guide. To install MySQL Server, execute the following command in a terminal window.

# sudo apt-get install mysql-server  

Once installation is done, open the MySQL command-line interface and connect as the root user.

# mysql -u root -p  
Password: (enter the root password)  

Once you logged in as the root user, now you can create the database for EJBCA. In this guide we named ejbca as our database name.

Mysql> CREATE database ejbca;  

Once previous step is done successfully, a user should be created for the database, and the specific access rights should be granted to the ejbca database. As with the database, we give the same name ejbca to the newly created user.

Mysql> USE ejbca;  
Mysql> CREATE user ’ejbca’@’127.0.0.1’ IDENTIFIED BY ’ejbca’;  
Mysql> GRANT SELECT, UPDATE, DELETE, CREATE on ejbca.* to \  
’ejbca’@’127.0.0.1’;  

This finishes the installation and configuration of the database system which is necessary for setting up an EJBCA.