Config Mysql in Laragon

* config in my.ini

Example allow user root access from any IP

UPDATE mysql.user SET host='%' WHERE user='root';
FLUSH PRIVILEGES;

ALTER USER 'root'@'%' IDENTIFIED BY 'root';

Update my.ini

bind-address=0.0.0.0

Thank you.

Configuration for Quick add in Laragon

Tools / Quick add / Configuration..
-----------------------------------------

#PHP
php-5.5=https://windows.php.net/downloads/releases/archives/php-5.5.38-Win32-VC11-x64.zip
php-5.6=https://windows.php.net/downloads/releases/archives/php-5.6.40-Win32-VC11-x64.zip
php-7.0=https://windows.php.net/downloads/releases/archives/php-7.0.33-Win32-VC14-x64.zip
php-7.1=https://windows.php.net/downloads/releases/archives/php-7.1.33-Win32-VC14-x64.zip
php-7.2=https://windows.php.net/downloads/releases/archives/php-7.2.34-Win32-VC15-x64.zip
php-7.3=https://windows.php.net/downloads/releases/archives/php-7.3.33-Win32-VC15-x64.zip
php-7.4=https://windows.php.net/downloads/releases/archives/php-7.4.32-Win32-vc15-x64.zip
php-8.0=https://windows.php.net/downloads/releases/archives/php-8.0.29-Win32-vs16-x64.zip
php-8.1=https://windows.php.net/downloads/releases/archives/php-8.1.25-Win32-vs16-x64.zip
php-8.2=https://windows.php.net/downloads/releases/archives/php-8.2.12-Win32-vs16-x64.zip

------------------------------------------------------

#Nodejs
node-10=https://nodejs.org/download/release/latest-v10.x/node-v10.24.1-win-x64.zip
node-11=https://nodejs.org/download/release/latest-v11.x/node-v11.15.0-win-x64.zip
node-12=https://nodejs.org/download/release/latest-v12.x/node-v12.22.12-win-x64.zip
node-13=https://nodejs.org/download/release/latest-v13.x/node-v13.14.0-win-x64.zip
node-14=https://nodejs.org/download/release/latest-v14.x/node-v14.21.3-win-x64.zip
node-15=https://nodejs.org/download/release/latest-v15.x/node-v15.14.0-win-x64.zip
node-16=https://nodejs.org/download/release/latest-v16.x/node-v16.20.2-win-x64.zip
node-17=https://nodejs.org/download/release/latest-v17.x/node-v17.9.1-win-x64.zip
node-18=https://nodejs.org/download/release/latest-v18.x/node-v18.19.0-win-x64.zip
node-19=https://nodejs.org/download/release/latest-v19.x/node-v19.9.0-win-x64.zip
node-20=https://nodejs.org/download/release/v20.17.0/node-v20.17.0-win-x64.zip
yarn=https://github.com/yarnpkg/yarn/releases/download/v1.22.21/yarn-v1.22.21.tar.gz

------------------------------------------------------

# MySQL
mysql-8.0=https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.30-winx64.zip
mysql-5.7=https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.39-winx64.zip
mysql-5.6=https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.51-winx64.zip

------------------------------------------------------

# MongoDB https://www.mongodb.com/download-center/community
mongodb-4=https://fastdl.mongodb.org/win32/mongodb-win32-x86_64-2008plus-ssl-4.0.3.zip

------------------------------------------------------

# MariaDB
mariadb10=https://archive.mariadb.org/mariadb-10.9.8/winx64-packages/mariadb-10.9.8-winx64.zip
mariadb11=https://archive.mariadb.org/mariadb-11.3.1/winx64-packages/mariadb-11.3.1-winx64.zip

------------------------------------------------------

# Postgresql
postgresql-13=https://get.enterprisedb.com/postgresql/postgresql-13.5-1-windows-x64-binaries.zip
postgresql-14=https://get.enterprisedb.com/postgresql/postgresql-14.5-1-windows-x64-binaries.zip
postgresql-15=https://get.enterprisedb.com/postgresql/postgresql-15.5-1-windows-x64-binaries.zip
postgresql-16=https://get.enterprisedb.com/postgresql/postgresql-16.1-1-windows-x64-binaries.zip

------------------------------------------------------

# Tools
phpmyadmin=https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.zip
dbeaver=https://dbeaver.io/files/dbeaver-ce-latest-win32.win32.x86_64.zip

------------------------------------------------------
#Go
go-1.24=https://go.dev/dl/go1.21.4.windows-amd64.zip

------------------------------------------------------
ruby=https://dl.bintray.com/oneclick/rubyinstaller/ruby-2.3.3-x64-mingw32.7z
devkit=https://github.com/leokhoa/laragon/releases/download/portable/devkit.7z

------------------------------------------------------
java=https://github.com/leokhoa/laragon/releases/download/portable/jdk-8u131-windows-x64.7z

Thank you

Install Mysql for Laragon

* Check system type window

- Under Control Panel, click System => check system type

* Download and install softwares

- Mysql
+ mysql-8.0=https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.30-winx64.zip
+ mysql-5.7=https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.39-winx64.zip
+ mysql-5.6=https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.51-winx64.zip
Then extract and move mysql folder to C:\laragon\bin\mysql

- Microsoft Visual C++
+ Version:10.0: https://www.microsoft.com/en-us/download/details.aspx?id=26999
=> Supported Operating Systems Windows XP, Windows Server 2003 R2 x64 editions, Windows Vista Service Pack 2, Windows Server 2003 R2 (32-Bit x86), Windows Server 2008 R2, Windows 7
/ Note: My PC window10, 64-bit operating system, x64-based processor, install vcredist_x64 Version:10.0 for mysql-5.6 run successful, but install Version:2012.4 then error, can not find vcredist_x64.

+ Version:2012.4: https://www.microsoft.com/en-us/download/details.aspx?id=30679
=> Supported Operating Systems Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2003, Windows Server 2008 R2 SP1, Windows Server 2008 Service Pack 2, Windows Server 2012, Windows Vista Service Pack 2, Windows XP

* Delete Mysql folder

- delete folder C:\laragon\data\mysql when you install mysql-5.6 or mysql-5.7 (because mysql-5.6 and mysql-5.7 when install laragon create same folder name in C:\laragon\data\mysql)

user: root

pass: ''

Thank you