In addition to using the embedded HyperSQL database, you can install a MySQL database or use an existing MySQL or Oracle database. The following procedure explains how to install a new MySQL database.
Prerequisites
See System Requirements for supported versions of MySQL.
Linux (Red Hat)
- Download MySQL from http://dev.mysql.com/downloads/mysql/. Be sure to select the correct download for the correct platform and architecture.
- Log into the system as
root
. Install MySQL Server.
rpm –i MySQL-server-<version>.<arch>.rpm
By default, MySQL is configured to start when the system starts.
To start MySQL manually:
/etc/init.d/mysql start
To stop MySQL manually:
/etc/init.d/mysql stop
To restart MySQL manually:
/etc/init.d/mysql restart
Windows
- Download MySQL from http://dev.mysql.com/downloads/mysql/. Be sure to select the correct download for the correct platform and architecture.
- You should delete
C:\Users\All Users\MySQL
if MySQL had been previously installed. - Run the installer as Administrator.
Add the MySQL bin folder to the system PATH. For example:
set PATH=%PATH%;C:\Program Files\MySQL\MySQL Server 8\bin
MySQL will be automatically configured to start when the system starts.
To start MySQL manually, run services.msc and look for the MySQL8 service.