5.2.4. Creating Tables

To create the necessary tables in the database:

In the /mysql/bin directory connect to the database with the following command:
```
$ mysql -uroot -p<password> -h <IP address to the MySQL Server>
```
Show existing databases:
```
mysql> show databases;
```
The current databases should be displayed.
Create the PCC database:
```
mysql> create database pcc;
```
The PCC database should now be created.
Connect to the database:
```
mysql> use pcc;
```
The database should now be changed to pcc.

Create the tables by running the scripts pcc_bucket_mysqlc.sql and pcc_config_mysqlc.sql:

mysql> source <path>/pcc_bucket_mysqlc.sql;
mysql> source <path>/pcc_config_mysqlc.sql;

verify that the creation has been done by either:

mysql> show tables;
mysql> describe bucket_storage;
mysql> describe config_storage;