GUIDE TO MySQL SERVER INSTALLATION

GUIDE TO MySQL SERVER INSTALLATION
The operation of the database in the HD35AP-S program requires previous installation
of MySQL database management system, included in the CD-ROM of HD35AP-S software.
Proceed as follows:
1. Insert the CD-ROM of HD35AP-S software and select Install MySQL.
2. If a protection warning appears, select Run.
3. In the installation window that appears, select Next.
4. Select the option I accept the terms in the license agreement and press Next.
HD35AP-S
–1–
MySQL Server
5. Select Typical.
6. Select Install.
7. If a window appears asking for user authorisation, select Continue.
8. Wait for the completion of installation.
HD35AP-S
–2–
MySQL Server
9. At the end of the installation, a window with information about MySQL Enterprise appears
on top of the installation window. Close such window.
10.
In the installation window press Finish, leaving the option Launch the MySQL Instance
Configuration Wizard selected.
11.
If a window appears asking for user authorisation, select Continue.
HD35AP-S
–3–
MySQL Server
12.
In the configuration window that appears, select Next.
13.
Select Next, leaving the option Detailed Configuration selected.
14.
Select Next, leaving the option Developer Machine selected.
HD35AP-S
–4–
MySQL Server
15.
Select Next, leaving the option Multifunctional Database selected.
16.
Select Next, without changing the settings.
17.
Select Next, leaving the option Decision Support (DSS)/OLAP selected.
HD35AP-S
–5–
MySQL Server
18.
Leave the options Enable TCP/IP Networking and Enable Strict Mode selected. Select the
option Add firewall exception for this port. Take note of the port number (e.g. 3306 in
the figure) because you will need it to configure the HD35AP-S software. Select Next to
proceed.
19.
Select Next, leaving the option Standard Character Set selected.
20.
Leave the option Install As Windows Service selected. Select the option Include Bin
Directory in Windows PATH. Select Next to proceed.
HD35AP-S
–6–
MySQL Server
21.
Enter the database password in the field Enter the root password and write it again in the
field Retype the password. Take note of the password because you will need it to configure
the HD35AP-S software.
22.
If the database should be accessible also from other PCs of the network, select the option
Enable root access from remote machines. Select Next to proceed.
23.
Select Execute.
HD35AP-S
–7–
MySQL Server
24.
Wait for the completion of the configuration. At the end, select Finish.
Note: if an anti-virus program is active during installation, the confirmation of the changes to
the operating system registry may be required. In this case, confirm the changes to correctly
proceed with the installation.
Note: if the HD35AP-S program can not access the database after the installation and the
configuration of MySQL, check the following points:
1. Open Windows® TASK MANAGER and select the SERVICES list. Check if MySQL appears in
the list and if the process is RUNNING in the STATUS column.
If the MySQL service is listed but it is not running, select the MySQL row, press the mouse
right button and select the command START.
If the MySQL service is not listed, go to the BIN subfolder of MySQL installation folder
(usually C:\programs\MySQL\...), run the program MySQLInstanceConfig.exe and repeat the
above procedure from point 12.
2. If the database should be accessible from other PCs of the network (function available
with HD35AP-PLUS only) and a firewall program is active, check that the access to MySQL is
not blocked by the firewall: in this case, insert an exception for MYSQL server in the firewall
settings and allow the access from all the PCs of the network.
BACKUP OF THE DATABASE
For safety, regularly make a backup of the data in the database by using the MySQL Backup
utility which is installed in the PC together with the HD35AP-S software.
HD35AP-S
–8–
MySQL Server