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
© Copyright 2024