Creating Tables

To create the necessary tables in the database:

1. In the /mysql/bin directory connect to the database with the following command:

   $ mysql -uroot -p<password> -h <IP address to the MySQL Server>

    

2. Show existing databases:

   mysql> show databases;

   The current databases should be displayed.
    

3. Create the PCC database:

   mysql> create database pcc;

   The PCC database should now be created.
    

4. Connect to the database:

   The database should now be changed to pcc.
    

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

    

6. verify that the creation has been done by either:

    

7. Exit MySQL when you are done: