Upgrade MySQL 8.0.30 to 8.4.2 to 9.0.1

[Donny-168]

Hi...i just upgrade MySQL 8.0.30 to 9.0.1, i follow all instruction and run ok...status MySQL 9.0.1 Started...and try to change root password and success...but i can't still connect my localhost 3307...when i back to use MySQL 8.0.30...everything is ok.
What should i do to solve this problem?

[Donny-168]

SOLVE

1. Before upgrade, backup file in folder Laragon/Data
2. Edit file at folder laragon/MySql/Bin/MySQL xxxxx/My.Ini
3. Make file My.INI into "Read Only" file
4. Use HeidiSQL to connect MySQL especially MySQL 9.0

My.Ini 8.0.30

My.Ini 8.4.2

My.Ini 9.0.1

Read Only

[Ringoinmel]

I got this error. Any idea? Thanks

2024-11-16T12:11:50.318872Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default_authentication_plugin=mysql_native_password'.
2024-11-16T12:11:50.323694Z 0 [ERROR] [MY-010119] [Server] Aborting

[Ringoinmel]

fixed and now I got SQL version 9.1.0

[Donny-168]

fixed and now I got SQL version 9.1.0

Hi, can u share how to configure My SQL ver 9.1.0?...

[rpascolo]

Follow instructions to move to 8.4.2 : https://gist.github.com/meorajrul/b57803bf1b4ddfd2f93e6ad37c3ac5f2
Instructions are the same for 9.1 (adapt datadir and basedir to match your configuration)

[Donny-168]

Follow instructions to move to 8.4.2 : https://gist.github.com/meorajrul/b57803bf1b4ddfd2f93e6ad37c3ac5f2 Instructions are the same for 9.1 (adapt datadir and basedir to match your configuration)

[Ringoinmel]

my.ini as below for SQL 9.1.0 and also make it read only

[client]
#password=your_password
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
key_buffer_size=256M
max_allowed_packet=512M
table_open_cache=256
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=4M
myisam_sort_buffer_size=64M
thread_cache_size=8

secure-file-priv=""
explicit_defaults_for_timestamp=1
datadir= "C:/laragon/data/mysql-9.1"
#default_authentication_plugin=mysql_native_password

[mysqldump]
quick
max_allowed_packet=512M