2.5 Command-line Repository Creation

1. Create the Database
2. Create the Schema

This step is for creating the MySQL aquadataserver database and its contained schema via the command-line.

Create the Database

Below are the required commands within MySQL, run as the MySQL database root, to create the required aquadataserver database user. The `aquadataserver`@'%' fragment enables the Aqua Data Server application to access the aquadataserver database irrespective of whether the database is installed on the same physical server as the Aqua Data Server application, or on a remote server elsewhere on your network.

mysql -u root -p <press enter and it will ask mysql root password>
        -mysql> create database aquadataserver default character set utf8 default collate utf8_unicode_ci; <press enter>
        -mysql> grant all on *.* to 'aquadataserver'@'%' identified by '(type in the aquadataserver password)'; <press enter>
        -mysql> exit;<press enter>

Create the Schema

Once the database has been created, the schema needed for Aqua Data Server must be created within the aquadataserver database.

At this stage we need to log in to MySQL server as aquadataserver and run the  aquadataserver_schema.sql script, found in the <install_directory>/schema/ directory to create the application objects & data necessary for Aqua Data Server. This script uses "go" as the statement separator because it was designed for use in Aqua Data Studio. Please make sure you execute the following commands in sequence to set "go" as MySQL's statement separator and then set it back to its default separator (";").

mysql -u aquadataserver -p <press enter and it will ask aquadataserver password>
        -mysql> delimiter 'go' <press enter>
        -mysql> use aquadataserver <press enter>
        -mysql> source <install_directory>/schema/aquadataserver_schema.sql <press enter> 
        -mysql> delimiter ';' <press enter> 
        -mysql> exit <press enter>