[Tutorial] How to add another MySQL version


  • | 62 points

    Now you can add new version MySQL 8.0.12
    you can download mysql-8.0.12-winx64.zip extract in bin/mysql
    0_1534400410568_Laragon-MySQL-8.jpg
    0_1534400519850_PHPMyAdmin MySQL-8.jpg


  • | 322 points

    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


  • | 1649 points

    Hello,

    For me I have : Error occurred: Query against mysql.user table failed when checking the mysql.session.


  • | 833 points

    Hi, just dropped by this thread and then try to update mysql to mysql 8

    Here what i've done :

    1. Windows 10 64 bit runing laragon Full 3.3.3
    2. Download mysql 8 from here http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-8.0/mysql-8.0.13-winx64.zip
    3. Stop running services from laragon GUI
    4. Rename laragon\data\mysql to C:\laragon\data\mysql_backup, just in case something bad happens
    5. Extract mysql-8.0.13-winx64.zip to C:\laragon\bin\mysql, now it has two folders: mysql-5.7.19-winx64 and mysql-6.0.13-winx64
    6. Ask laragon to use mysql-8 via it's popup-menu from it's try icon
    7. Start all laragon services from laragon GUI
    8. Mysql-8 apparently create folder mysql-8 in laragon\data, so I think step number 4 can be skipped, but I would rather do it
    9. Try to log using heidisql, it works
    10. Try to migrate my laravel database using php artisan migrate, successful

    I assume my installation of mysql-8 is successful. Hope this could help you!!


  • | 1649 points

    @kidipridi yes but in heidySQL when you go to menu Outils > users to want to add users it say errors ...


  • administrators
    | 110144 points

    @Paul-BOREL : You can try updating HeidiSQL:

    1. Download https://www.heidisql.com/builds/heidisql64.r5332.exe
    2. Overwrite the C:\laragon\bin\heidisql\heidisql.exe

  • | 1649 points

    @leokhoa hello i have the last version...
    It say that have not mysql.user....


  • | 833 points

    @leokhoa @Paul-BOREL

    Oh I see now, just tried and got the same erros. It's actually because MySQL-8 didn't create the default database it needs to work normally. Been tried to google for any solution with no luck ;( and because I don't have any other mysql-8 installation, I can't figure out which part is missing from Mysql's databases.

    But finally, I found and tried my own trick and it works like charm :

    1. Stop mysql
    2. Delete folder laragon\data\mysql-8
    3. Rename my old mysql5.7 data which was laragon\data\mysql_backup to mysql-8 (Actually i didn't rename it, I just copied and pasted it, then I rename it to mysql-8, just in case any trouble should appears)
    4. Start mysql
    5. From terminal, change directory to laragon\bin\mysql\mysql-8.0.13-winx64\bin
    6. Run mysql_upgrade -u root

    Wish u luck, mate!


  • | 31 points

    Ya he hecho este cambio pero no funciona para la version de windows 32bit. Alguien ha realizado este cambio en windows 32 bit.?


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.