[Tutorial] How to add another MySQL version

[leokhoa]

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]

1. Download MySQL 5.7 (64-bit) or 32-bit:
   https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-winx64.zip

---

2. 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
      -- .............

---

3. 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

[leokhoa]

Some pics:

1. Folder structure:
   

2. Menu:
   

[akash]

@leokhoa : Thanks!!

[krip]

Hi @leokhoa if i want to switch with mysql version 5.1.73, which package and where do I need to download?

[leokhoa]

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.

[krip]

@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..

[leokhoa]

@krip: Let me check and get back to you

[leokhoa]

@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.

[krip]

@leokhoa Weird, do you use the same package (mysql-noinstall-5.1.73-win32.zip)?
I getting error from that package

[leokhoa]

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.

[krip]

@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
λ

[leokhoa]

@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/2

Btw, how about running MySQL 5.7.13 with compatibility mode?
https://forum.laragon.org/topic/197/edit-mysql-configuration-file/

[leokhoa]

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)

1. Backup your databases using mysqldump
2. Rename current data dir to data-backup
3. Copy your data dir in bin/mysql/mysql-noinstall-5.1.73-win32 to the former data dir place
4. Start Laragon and restore former databases from the dump file

This should work without any problem.

[krip]

@leokhoa great! it worked! thanks!

[Bsienn Khan]

I Installed Laragon 3.2.3 (Also tried with 3.1 as well)
I updated to latest mysql 8 from the following link in pic

But I get error after switching to new mysql and starting it.

0_1527594583748_mysqllog.txt

[120891]

@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 pic

But I get error after switching to new mysql and starting it.

0_1527594583748_mysqllog.txt

i got same error too, even after i install MySQL using MySQL installer, i cannot access it

[john5db]

@Bsienn-Khan

HI ,
Did you soled it ?
I am also facing same issue.

[Bsienn Khan]

@john5db As you ca see, funny enough no one replied. I still can't add latest mysql.

[Ismail.IndoTech]

Now you can add new version MySQL 8.0.12
you can download mysql-8.0.12-winx64.zip extract in bin/mysql

[Bsienn Khan]

So, as mentioned by @Ismail-IndoTech I updated latest mysql and it partly worked.

Got same error after updating myql, then did the following:

1. Updated Laragon from 3.2 => 3.4
2. Extracted latest mysql in bin/mysql
3. Started Laragon, got cryptic error (was related to user permission/password, basically needed to tell Laragon/mysql that I upgraded mysql)
4. Ran "mysql_upgrade -u root" either from cmd or run the terminal from Laragon launcher where we start/stop services

Everything works fine now.

Mention @john5db