[Tutorial] How to add another MySQL version
-
Hello,
For me I have : Error occurred: Query against mysql.user table failed when checking the mysql.session.
-
Hi, just dropped by this thread and then try to update mysql to mysql 8
Here what i've done :
- Windows 10 64 bit runing laragon Full 3.3.3
- Download mysql 8 from here http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-8.0/mysql-8.0.13-winx64.zip
- Stop running services from laragon GUI
- Rename laragon\data\mysql to C:\laragon\data\mysql_backup, just in case something bad happens
- 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
- Ask laragon to use mysql-8 via it's popup-menu from it's try icon
- Start all laragon services from laragon GUI
- 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
- Try to log using heidisql, it works
- 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!!
-
@kidipridi yes but in heidySQL when you go to menu Outils > users to want to add users it say errors ...
-
@Paul-BOREL : You can try updating HeidiSQL:
- Download https://www.heidisql.com/builds/heidisql64.r5332.exe
- Overwrite the
C:\laragon\bin\heidisql\heidisql.exe
-
@leokhoa hello i have the last version...
It say that have not mysql.user....
-
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 :
- Stop mysql
- Delete folder laragon\data\mysql-8
- 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)
- Start mysql
- From terminal, change directory to laragon\bin\mysql\mysql-8.0.13-winx64\bin
- Run mysql_upgrade -u root
Wish u luck, mate!
-
Ya he hecho este cambio pero no funciona para la version de windows 32bit. Alguien ha realizado este cambio en windows 32 bit.?
-
@Ismail.IndoTech efectivamente con la versión 8.0.12
dejo el link https://downloads.mysql.com/archives/community/
-
@rcarhuaricra
quizás esta opción de autenticación tenga algo que ver para que no conecte el MySQL 8 con esta versión de laragon, de momento funciona bien con la version 8.0.12 saludos
-
Here is how i did:
- Delete your data folder: located at "C:\laragon\data" by default:
- Download latest Community MySQL Server(zipped): https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.17-winx64.zip
- Extract it to default mysql bin: Mine's here -> C:\laragon\bin\mysql
- Should look like this:
- Then open Cmder and type: cd C:\laragon\bin\mysql\mysql-8.0.17-winx64\bin followed by
- mysqld --initialize --console (write the password generated for later)
- type start mysqld
- then with the password generated -> mysql -u root -p
- and alter the password to the laragon default's: ALTER USER 'root'@'localhost' IDENTIFIED BY '';
- Should return an QUERY OK.
- type exit
- on the other cmder tab close mysqld hitting ctrl+c
-
If you're using phpMyAdmin you should see a screen like this when visiting http://localhost/phpmyadmin/index.php
-
Thank you so much! This did the tricked and worked for me!
-
@kidipridi
Thank you very much, I have been with this problem for a few days and thanks to your steps I have been able to change my version of the MySQL.