Running MySQL on a Separate Machine

If you need Orchestrator to run the MySQL database on a remote machine, you must set up MySQL before installing Orchestrator. Follow these steps to install and configure MySQL on a separate machine.

Download and install the Aspera Common Components, only, using the procedure in Installing Orchestrator.
Initiate setup and configuration of the MySQL database.
Run the following command to initiate the configuration process::
```
# asctl mysql:setup
```

Select a setup mode.

Streamlined: A simple setup with all components running on this computer.
Detailed:    An advanced configuration (e.g. non-standard ports or not all components running on a single server)

Streamlined or detailed setup (s/d)? (current: s) d

Enter "s" to select streamlined setup.

Enter "d" (detailed) if you require an advanced configuration; for example, your system utilizes non-standard ports or not all components are running on a single server.

The following table describes the system prompts for the two setup modes:

System Prompt	Mode (s or d)	Details
MySQL will run on this machine (y/n)?	d	Default is "`y`"
What port would you like MySQL to listen on?	d	Default is `4406`
Enter a new MySQL root password.	s, d	Enter and confirm the MySQL `root` password. Note: Save this for future reference.
MySQL will need to start/restart during configuration. Continue (y/n)?	s, d	Default is "`y`" Note: If you enter "`n`", the system will exit setup.

Enter "y" to confirm the settings.

===================== Settings =====================
MySQL
  Enabled:     true
  Port:        4406

Are these settings correct? (y/n/x with x for exit) y

MySQL starts.

MySQL
  Enabling MySQL...                                            done
  Installing startup script...                                 done
  Setting up db space watcher...                               done
  Creating 'mysql'...                                          done
       .    .    .
  Starting MySQL                                               OK
  Setting MySQL password                                       OK
  Granting privileges                                          OK
  Updating version                                             OK

Enter "y" to restart MySQL.

MySQL needs to be restarted, restart it now (y/n)? (default:y) y
MySQL: Stop... done
MySQL: Start... done

Log in to the MySQL database with the root password.
To create the orchestrator database, enter the following:
```
create database orchestrator;
```
To allow Orchestrator to access the remote MySQL database, enter the following.
The placeholder ip_address is where you enter the IP address for the server running Orchestrator.
```
GRANT ALL PRIVILEGES ON orchestrator.* TO 'root'@'ip_address' IDENTIFIED BY 'aspera' WITH GRANT OPTION;
```
Note:
- For high availability environments, repeat this command with the ip_address for the second node.
- A less secure option is to replace ip_address with "%" (which indicates "all hosts").