3. What about the data?
This procedure will install MariaDB into your Laragon installation.
A new folder
\LARAGON\data\mariadb-x.x\ wil be created.
It will not touch the existing MySQL database.
This means you’ll have to :
- export all existing databases BEFORE adding MariaDB
- import all exported databases AFTER installing MariaDB
4. Laragon - Add MariaDB
- Go to MariaDB Downloads and select the version you want to install.
- Filter the available downloads by selecting the Windows checkbox.
- Then rightclick the mariadb-x.x.x-winx64.zip version and select Copy hyperlink.
- In the Tools section, select Quick Add → Configuration. This will open the file
- Change the line
# mariadb10.3=https://downloads.mariadb.org/f/mariadb-10.3.10/winx64-packages/mariadb-10.3.10-winx64.zip/from/http%3A//sgp1.mirrors.digitalocean.com/mariadb/?serveby replacing the hyperlink after the “=” sign with the hyperlink you previously copied from the MariaDB Downloads page.
- Then adjust the MariaDB version just before the “=” sign to reflect the proper version.
- Remove the “#” sign at the beginning of the line.
- The result should look like
5. Inspecting the new database
- In the Laragon Button Menu, click on the Database button.
- In a fresh Laragon installation, the default user is root and the password is not set.
- Select your preferred language and log in to phpMyAdmin.
- phpMyAdmin may complain about the phpMyAdmin configuration storage not being completely configured.
Inside the warning, click on the link Find out why.
Inside de next notice, click on the link Create.
phpMyAdmin will then create and configure the database named phpmyadmin.
Click on the Home button. The warning should be gone now.
You have now installed MariaDB into your Laragon installation.
You can now start importing your databases.
After succesful import and testing, you can delete the obsolete mySQL folders in :
6. Character Set and Collation
In some cases you might want to configure the MariaDB UTF 8 settings by specifying the character set and the collation.
In my case, the preferred character set is utf8mb4 and the collation is utf8mb4_unicode_ci.
If you want to force MariaDB to use this settings, you’ll have to add them to these 2 files :
In both files, add the settings to the [mysqld] section :
##UTF 8 Settings character_set_server=utf8mb4 collation_server=utf8mb4_unicode_ci