[Tutorial] How to add another MySQL version
-
Adding another MySQL version is very easy and safe with Laragon.
Hint: This tutorial also applies for MariaDB.
https://downloads.mariadb.org/mariadb/10.2.6/#os_group=windows
[Download the MariaDB 64-bit version]- Download
MySQL 5.7 (64-bit)
or 32-bit:
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-winx64.zip
- Extract the downloaded to: {LARAGON_ROOT}\bin\mysql\mysql-5.7.18-winx64 (see below Note for MariaDB)
C:\laragon -- bin -- mysql -- mysql-5.7.18-winx64 -- .............
- Select the new version at: Laragon Menu > MySQL > Version > mysql-5.7.18-winx64
Very easy huh. That's all forks!
Note: If you use MariaDB, extract it to: {LARAGON_ROOT}\bin\mysql\mariadb-10.2.6-winx64, Laragon will automatically create correspond DataDir for MariaDB on
data/mariadb
- Download
-
Some pics:
-
Folder structure:
-
Menu:
-
-
After doing this, on accessing the tables it throws following error:
On runnig "php artisan migrate" in command line:
Please hehp.
-
@akash :
In your case, you can do this:- Switch back to the former MySQL
- Dump your databases
- Switch to the prefer version
- Restore your databases (You can create other database names to avoid conflicts)
-
@leokhoa : Thanks!!
-
Hi @leokhoa if i want to switch with mysql version 5.1.73, which package and where do I need to download?
-
MySQL 5.1.73 is too old. I haven't tested Laragon with older version like that and I don't know whether Oracle still keeps Windows download for that version or not.
-
@leokhoa Hi, thank for reply. Does this is the correct package ? http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/mysql-noinstall-5.1.73-win32.zip
Yeah, I know this is old version. But our server still use this old version mysql..
-
@krip: Let me check and get back to you
-
@krip: It works.
PS: Though some addon functions of Laragon such as Auto create database, Reset and generate root password will not work. However, you can do them manually.
-
@leokhoa Weird, do you use the same package (mysql-noinstall-5.1.73-win32.zip)?
I getting error from that package
-
I use mysql-noinstall-5.1.73-win32.zip. You must completely stop MySQL and try again.
PS: I got nearly the same error, so I switched to the former one than switched back and it worked for me.
-
@leokhoa It tried turn off mysql.. switches mysql version on and off.. still no luck..
D:\laragon\www Tue 08/23/2016 14:56:13.65 λ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.13-log MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SELECT VERSION(); +------------+ | VERSION() | +------------+ | 5.7.13-log | +------------+ 1 row in set (0.05 sec) mysql> exit Bye D:\laragon\www Tue 08/23/2016 14:57:16.96 λ mysql -u root ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) D:\laragon\www Tue 08/23/2016 14:58:02.76 λ
-
@krip : Look like you created some databases with MySQL 5.7.13
I tested on a newly created Laragon environment.
Could you please backup your database then try again in new environment with no user database:
Reference: https://forum.laragon.org/topic/201/mysql-mariadb-not-running-in-2-0-4/2Btw, how about running MySQL 5.7.13 with compatibility mode?
https://forum.laragon.org/topic/197/edit-mysql-configuration-file/
-
How to add old version of MySQL for your case: (http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/mysql-noinstall-5.1.73-win32.zip)
- Backup your databases using mysqldump
- Rename current data dir to data-backup
- Copy your data dir in bin/mysql/mysql-noinstall-5.1.73-win32 to the former data dir place
- Start Laragon and restore former databases from the dump file
This should work without any problem.
-
@leokhoa great! it worked! thanks!
-
I Installed Laragon 3.2.3 (Also tried with 3.1 as well)
I updated to latest mysql 8 from the following link in picBut I get error after switching to new mysql and starting it.
-
@Bsienn-Khan said in [Tutorial] How to add another MySQL version:
I Installed Laragon 3.2.3 (Also tried with 3.1 as well)
I updated to latest mysql 8 from the following link in picBut I get error after switching to new mysql and starting it.
i got same error too, even after i install MySQL using MySQL installer, i cannot access it
-
HI ,
Did you soled it ?
I am also facing same issue.
-
@john5db As you ca see, funny enough no one replied. I still can't add latest mysql.