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: