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. Look for the latest Stable release.
- Under Package Type, choose ZIP file.
- Click the Download button and save the file to your download folder.
- In the Laragon Button Menu, stop all services by clicking the Stop All button.
- In the MySQL section, select Version → mariadb-x.x.x-win64.
- In the Laragon Button Menu, click on the Start All button. Grant access to the mysql.exe service.
- Laragon has now created a new data folder
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