MySQL 5.6 Installation and Configuration
Introduction
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 following describes the steps to complete the installation process of the MySQL server for the installation of Appspace.
Step 1
Locate and launch the MySQL 5.6 installer file on your server machine.
If prompted, click Run to proceed through the security warning.
Step 2
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.
Step 5
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)
Danger
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.
Step 9
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.
Step 10
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.
Warning
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.
Step 11
You may optionally choose to assign/change the Windows Service Name or keep the default value. Check the box for ‘Start the MySQL Server at System Startup’. Click Next to continue.
Step 12
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.
Step 13
Click Execute on the ‘Apply Server Configuration’ window to begin the configuration process. Allow a few minutes for the configuration process to complete.
Step 14
Click Finish on the ‘Installation Complete’ window to exit the installer.
Note
You have completed the MySQL 5.6 Installation and Configuration. You may now proceed to the MySQL Setup (Workbench) article.