3. Backup databases
As always, backup all your databases before starting the manipulations!
4. Laragon - Updating MySQL
- Download the latest Community Server (x86, 64-bit) MySQL version as a ZIP archive from dev.mysql.com into your \Downloads\ folder.
- The packed file is named for instance mysql-8.0.23-winx64.zip.
- Unpack the downloaded ZIP archive in a folder with the same name, for instance mysql-8.0.23-winx64.
- Move the complete \mysql-8.0.23-winx64\ folder to the \bin\mysql\ folder of your Laragon installation.
5. Character Set and Collation
In some cases you might want to configure the MySQL 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 MySQL 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
6. Migrating from MySQL 5.xx to MySQL 8.xx
- Stop Laragon.
- In the menu, select Tools → Quick add → Configuration.
- Uncomment the mysql-8.0 line
(line 12; delete the # sign)
- Edit the MySQL version to the current version
(change mysql-8.0.13-winx64.zip to mysql-8.0.24-winx64.zip)
- Save & close the file.
- In the menu, select Tools → Quick add → mysql-8.0.
- Download and unpacking will start.
- After download, select MySQL → Version → mysql-8.0.24-winx64
- Make a copy of your existing \laragon\data\mysql\ folder and rename it to \laragon\data\mysql-8\
- Click Start All button.
- If Windows Firewall opens give appropriate permissions to MySQL.
7. MySQL Reset root password
In case you ever forget the root user password, Laragon provides an easy way to reset it.
- In the menu, select MySQL → Reset and generate a random password to root.
The default user for any fresh installed database driver is username root with no password.