Use the MySQL Monitor to create the required database using these commands:
Create a text-file (called create_publics.sql) and adds these lines to the file:
create table publics ( ip_address varchar (16) not null, protocol_port varchar (6) not null, public_key text not null )
Use this file to create the required database table within the SCOOBY database, as follows:
Use these commands to confirm that the creation of the database table has been successful:
With MySQL up-and-running, and the SCOOBY database in existence, the Key Server can now be installed and configured.