v8.01 (build: Jan 4 2020)

MySQL

If MySQL server was not installed before


It can be installed on Windows as well as on Unix.

The setup, as usual, is necessary to perform either on a separate server workstation or on administator's workstation (if separate server room is not available).

During installation process it is necessary to give access to server in the network and add Firewall server port to exceptions (this option may not available).
In Mirobase not only TCP port 3306 is supported, in odrer to set other port it is necessary to put it with a colon after server name with MySQL while connecting (for example, SERVER:3310).

If you need to use several SQL server instances it is necessary to specify other instance name (service for Windows) during installation process as well as other port (different from port by default 3306).

Also it is necessary to create a password for special embedded user "root". Later under this user it will be possible to login into database and change all settings. If it will be suggested to enter current password for root leave this field empty!
It is necessary to give access to database from remote workstations for this user by marking corresponding option in the settings (it may not available).
Attention! It is strongly recommended to create additional user with "DB Admin" permission rights (see below) and to perform all administrator's activities with database from its name but not from root!



















If it was not suggested to add server port Firewall to exception it is necessary to do it manually:




Attention! It is necessary to set the server variable max_allowed_packet for operations in software suite Mirobase.
In the MySQL server folder file my.ini (Windows) or my.cnf (Unix) in the section [mysqld] it is necessary to add the line:

max_allowed_packet=32M

It is important to restart MySQL server afterwards.

Attention! If this parameter is already set in configuration file, it is necessary only to change its value not adding a new one!

For MySQL version below 5.6 file my.ini is located in %ProgramFiles%\MySQL\MySQL Server x.xx\my.ini by default
For MySQL version 5.6 and higher file my.ini is located in C:\ProgramData\MySQL\MySQL Server x.xx\my.ini by default




If MySQL is already installed


If MySQL is already installed it is necessary to implement sequence of these actions for accurate work of Mirobase.

Run the application MySQLInstanceConfig for installed server setup and perform actions described in the previous part:
"If MySQL server was not installed before".
It is obligatory to setup the server variable max_allowed_packet described in the previous part:
"If MySQL server was not installed before".

Attention! See part "If MySQL server was not installed before".


MySQL server re-installation


SQL server deinstallation has to be performed in standard way through "Control panel->Program installation and deinstallation".
In such case Mirobase database file may remain or may not after server deinstallation (depends on the server version).
For server reinstallation it is recommended to delete it (as well as the whole \MySQL folder). Although the location of the database files depend on the server version.


© Mirobase