GUIDE TO MySQL SERVER 8.4 INSTALLATION
The operation of the database requires previous installation of MySQL database management system, included in the software package.
Attention!
If you are already using a database created with the previous version 5.5 of
MySQL Server, see note c) at the bottom of the document.
Proceed as follows:
1. Right click with the mouse on the file Autorun.exe of the software package and select Run as administrator.
2. Select Install MySQL.
3. If a protection warning appears, select “Run”.
4. In the installation window that appears, press Next.
5. Select the option “I accept the terms in the license agreement” and press Next.
6. Select Typical.
7. SelectInstall.
8. If a window appears asking for user authorisation, select “Continue”.
9. Wait for the completion of installation.
10. Press Finish, leaving the “Run MySQL Configurator” option selected.
11. If a window appears asking for user authorisation, select “Continue”.
12. In the “MySQL Configurator”
window that appears, press Next.
Note: in some systems, the item “Data Directory” may appear
instead of “MySQL Server Installation” under the “Welcome”
item on the left side of the window. This is normal and does not affect the
installation.
13. Select the “Configure this
server instance as a side-by-side installation” option.
Note: if the left side of the window displays “Data Directory”
instead of “MySQL Server Installation”, this window will not appear;
in this case, proceed directly to the next step.
14. Press Next.
Note: if the left side of the window displays “Data Directory”
instead of “MySQL Server Installation”, this window will display
only the "data directory" field.
15. Select Server Computer
in the “Config Type” field, write the number of a free port (e.g.
3307) in the “Port” field and press Next
(leave the “TCP/IP” and “Open windows Firewall ports for network
access” options selected).
Take note of the port number because it will be needed to configure the
application software.
16. Enter the database administrator
password (e.g. root) in the “MySQL Root Password”
and “Repeat Password” fields, then press Next.
Take note of the password because it will be needed to configure the application
software.
If additional users are to be added in addition to the administrator, defining
their credentials and privileges, this can be done by pressing the “Add
User” button before pressing Next. It is not necessary to press the “Add
User” button if the administrator installing the database will be the
only one with access to it.
17. Press Next (leave the “Configure MySQL Server as a Windows Service”, “Start the MySQL Server at System Startup” and “Standard System Account” options selected).
18. Press Next.
19. Press Next.
20. Press Execute.
21. Wait for the completion of the configuration. At the end, press Next.
22. If you want to copy the installation log to the clipboard, press the “Copy Log to Clipboard” button. Press Finish.
b) If the application software cannot
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.
2. If the database should be accessible from other PCs of the
network 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.
c) For users who are already
using a database created with the previous version 5.5 of MySQL Server:
installing MySQL Server 8.4 creates a new database; the existing MySQL Server
5.5 database is not altered. You can continue to save data in the previous database,
or start saving data in the new database, which has higher data security requirements.
In the latter case, the old database will no longer be updated.
The database to be used is selected by entering the corresponding credentials
in the application software settings; for example, “Tools >> MySQL
management” menu in the case of HD35AP-S or HD35AP-CFR21 softwareThe database
to be used is selected by entering the corresponding credentials in the application
software settings; for example, “Tools >> MySQL management”
menu in the case of HD35AP-S or HD35AP-CFR21 software; "MySQL setup"
panel in the case of HDServer1 software.
(*) The port number is just an example: enter the port number set during the installation of MySQL Server.
Data can be saved in the MySQL Server 8.4 database starting from revision 0.0.4.406 of the HD35AP-S or HD35AP-CFR21 application software, and from revision 1.0.0.211 of the HDServer1 application software.
11-11-2025