Fail to reset MySQL native password

[FrancescoBorzi]

Since MySQL 8.0 there is a new authentication mechanism by default that prevents some apps from logging in (see mysqljs/mysql#1507 for nodejs-based apps for example).

This affects Keira3 as well. This is a known issue and the solution is usually simple (see https://stackoverflow.com/q/65271160/3497671 ), just reset the password using mysql_native_password :

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

However in acore-docker this solution DOES NOT WORK. The query is executed without errors, but password doesn't get reset and the error persists.

I've tried by running the query from both HeidiSQL as well as directly from the MySQL server console using the bash command line inside the docker container, nothing worked.

[FrancescoBorzi]

@Yehonal as this prevents acore-docker users from using Keira3, it's quite critical. Can you please have a look at it?

[gr33k]

I also am running into this issue when trying to use https://github.com/masterking32/WoWSimpleRegistration

Do we have a solution for this problem? Thank you

[Helias]

The issue is related to the mysql client of the application.

We recently updated the mysql library inside Keira3 for the new version 3.4.3, so if someone runs the acore-docker using docker-compose up with the development versionof Keira3-3.4.3 it is possible to connect to the database using

host: localhost
port: 63306
username: root
password: password (if you do not change it, it's password the default one)
database: acore_world

I am closing this issue because it does not depend properly on acore-docker

[Yehonal]

GJ!!

…

On Wed, 2 Nov 2022, 12:33 Stefano Borzì, ***@***.***> wrote: Closed #2 <#2> as completed. — Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABD5FCYI3DY7BINB2HNZOLWGJGRVANCNFSM5LDLVKTA> . You are receiving this because you were assigned.Message ID: ***@***.***>