|Managing the MySQL Database|
After you have installed Console, you can further configure it to run the MySQL database on a remote machine. Follow these steps to run the web application and the MySQL database on two separate machines:
If the local account does not already exist, enter new credentials and click Next. The installer will create an account with the information you have entered. If the account exists (created through the previous installation), enter the account's password and click Next. If the existing user's password you have entered is incorrect, or you wish to change the Aspera service user, see Managing the Aspera Service Account.
On the MySQL machine, bring up a Command Prompt and execute this command to configure MySQL:
When started, the configuration program will ask you to use streamlined or detailed setup. Expect the following setup items in each setup method: (In detailed setup, answer y in the first question.)
|MySQL will run on this machine (y/n)? (default: y)||X|
|What port would you like MySQL to listen on? (default: 4406)||X||X|
|Where would you like MySQL to store data: (default: C:/Program files/Common Files/Aspera/Common/myql/data)||X|
|MySQL will need to start/restart during configuration. Continue (y/n)? (Current: y)||X||X|
Lastly, a setup summary shows your settings. Enter y to confirm, n to change settings, or x to quit the program without saving.
When finished, execute this command to allow access for the Console machine. Replace the highlighted items to match your configuration (Enter the Console machine's address in <Console_server_IP>, and your MySQL password in <mysql_password>):
asctl mysql:grant_remote_access <Console_server_IP> root <mysql_password>
On the Console machine, execute this command to configure it to run MySQL on a remote machine:
> asctl console:setup
Answer n to the following question:
MySQL will run on this machine (y/n)? (default: y)