MySQL 5.6 Installation and Configuration
The MySQL server database is a required component for the operation of Appspace. An instance of the MySQL server database must be installed and configured, prior to installing Appspace.
The instructions provided describe how to install MySQL server for the installation of Appspace.
Locate and launch the MySQL 5.6 installer file on your server machine.
If prompted, click Run to proceed through the security warning.
If prompted, click Yes to allow the program to install software on the local machine.
Similarly, click Yes to allow the program to make changes to the computer.
Check the box to accept the license terms and click Next on the ‘License Agreement’ window.
Select the Custom option on the ‘Choosing a Setup Type’ window and click Next to continue.
On the ‘Select Products and Features’ window, ensure the following options are selected and moved under the ‘Products/Features To Be Installed’ section.
- MySQL Server 5.6.23 (either the x86 or x64 version depending on your server)
- MySQL Workbench CE 6.2.3 (either the x86 or x64 version depending on your server)
Only select these 2 options. Leave all the other options unchecked. It is important to make sure that the other options (such as MySQL Connectors) are not selected during the MySQL installation.
Click Execute on the ‘Installation Progress’ window.
When the installation has completed, click Next to continue.
Click Next on the ‘Product Configuration’ window.
Begin the MySQL server configuration by selecting Server Machine from the Config Type drop-down menu. Under Connectivity, check ‘TCP/IP’ and set the ‘Port Number’ as 3306. Also check ‘Open Firewall port for network access’ and ‘Show Advanced Options’. Click Next to continue.
Enter the MySQL Root Password as: g56*k9lp (note: it is a lower case L between 9 and p). Confirm the password a second time and click Next.
You may choose your own custom MySQL password for the root account. The stated g56*k9lp is a suggested/recommended password and will be referenced at a later point in this guide. If you select your own custom password, please take special care to note and write it down to be used later.
You may optionally choose to hange the Windows Service Name or keep the default value. Check the ‘Start the MySQL Server at System Startup’ check box. Click Next to continue.
In the ‘Logging Options’ window, the ‘Slow Query Log’ option is selected by default. You may check additional options if desired. Click Next to continue.
Click Execute on the ‘Apply Server Configuration’ window to begin the configuration process. Allow a few minutes for the configuration process to complete.
Click Finish on the ‘Installation Complete’ window to exit the installer.
You have completed the MySQL 5.6 Installation and Configuration. You may now proceed to the MySQL Setup (Workbench) article.