The progress of BioStar2 Express Installation installs Maria DB 10.1.10, therefore BioStar2 SW is compatible with the version 10.1.10 of Maria DB.


If you install Maria DB to a different PC, we require to confirm the version of Maria DB.



How To Check Maria DB Version


There are two ways to confirm Maria DB version.


<Using Heidi SQL>

1. Download HeidiSQL.
2. Install and run HeidiSQL.
3. Enter the information below on Settings

  • Hostname/IP: 127.0.0.1

  • User: root

  • Password: [your root password]

  • Port: 3312

4. Click Open.

5. Click [Query].



6. Enter the below query and click ▶.


SELECT VERSION(); 



7. Confirm the result and see if the version of Maria DB is 10.1.10-MariaDB.



22. If the version is higher or lower than v10.1.10, visit to the below site and download Maria DB 10.1.10 x64.


Depends on the OS version of a machine, please download winx64 or win32.

https://downloads.mariadb.org/mariadb/10.1.10/



<Using MYSQL Workbench>

1.Open a web browser.
2.Access the following link
3.Click Download Now to download MySQL Workbench. 

500 

Caution: use the 6.3 version of Workbench, latest versions have issues with backup


4.Click Looking for previous GA versions then select version 6.3.10 and click download.


5.Click No thanks, just start my download. 

500 


6.Run the downloaded file.
7.It will ask you to install the prerequisites. Click Download Prerequisites

500 


8.The link will guide you to download the files below. Install if you don’t already have them:

9.After installing all the prerequisites, run the MySQL Workbench installer again.
10.Launch MySQL Workbench with administrator privileges.
11.Click the + sign. 

500 


12.Set a name for Connection Name.
13.Set the Port to 3312.
14.Enter your database administrator id in Username.
The account you configured in the BioStar 2 express installation is root.
15.Click Store in Vault … and enter password. 

500 


16.Click Test Connection and check that it is successful.
17.If you see a Connection Warning click Continue Anyway.
500 


18.Click Ok to connect to the database.


19. Click the below button.

20. Enter the below query and click the button.


SELECT VERSION();



21. Confirm the result and see if the version of Maria DB is 10.1.10-MariaDB.


22. If the version is higher or lower than v10.1.10, visit to the below site and download Maria DB 10.1.10 x64.


Depends on the OS version of a machine, please download winx64 or win32.



https://downloads.mariadb.org/mariadb/10.1.10/