2.3.1 Prerequisite: MySQL

Installing MySQL

1. Install MySQL
2. Stop the MySQL server process
3. Modify the /etc/mysql/my.cnf file file if the database is on a different computer than the Aqua Data Server
4. Start the MySQL server process

1. Install MySQL server for the Aqua Data Server application

Ubuntu

sudo apt-get install mysql-server <press enter>
        (enter a password for mysql root) <press enter>

Other Unix/Linux systems

Download the MySQL 5.1+, GA (Generally Available) installer for your OS at http://dev.mysql.com/downloads/mysql/ and follow the installation instructions at http://dev.mysql.com/doc/refman/5.1/en/installing.html

Grant All Privileges to ROOT

Before connecting to MySQL you will need to GRANT access to your user and machine. Because the MySQL JDBC driver uses TCP/IP sockets instead of Unix Domain Sockets, the security manager in MySQL server will use the HOSTS table to determine whether or not the connection should be allowed. To grant your user access use this syntax: "GRANT ALL PRIVILEGES ON [dbname].* to ’[user]’@’[hostname]’ identified by ’[password]’" to generate and execute an SQL command.

mysql -u root -p <enter the mysql root password and press enter>
        -mysql> GRANT ALL PRIVILEGES on *.* to `root`@'%' identified by '(type in the root password)' with grant option;<press enter>
        -mysql> exit;<press enter>

2. Stop the mysql server process

sudo /etc/init.d/mysql stop

3. Modify the /etc/mysql/my.cnf file if the database is on a different computer than the Aqua Data Server

You need to tell MySQL which IP address to bind to (to listen on) if the database is on a different computer than the Aqua Data Server installation. This should be the IP address of the machine that MySQL is installed on. This IP address is also specified in the aquadataserver.properties file, as described in step 3 of "Installing Aqua Data Server". See this link http://dev.mysql.com/doc/refman/5.1/en/option-files.html for information where configuration files are located and the order in which MySQL reads the configuration information.

sudo vi /etc/mysql/my.cnf

an example for this is:

bind-address=10.168.5.210

4. Start the mysql server process

sudo /etc/init.d/mysql start