Could it work with Mysql 5.7.41? #207

I set up the correct account and password, but the serial monitor tells me "Error: 76 = Access denied for user 'root'@'192.168.0.111(using password: YES)'".

First, I thought it was a password error. BUT I successfully accessed Mysql from CMD with the same account and password.

Then, I tried to access Mysql from other computer (different IP Address but on the LAN), and it was successfully.

Next, I set Mysql config to skip password authentication, and esp8266 successfully connected to Mysql !

So, I try to look at the code, and I find this fuction "scramble_password()" that form a SHA1 hash of the password. The documentation online shows that this applies to version 3.2 - 4.0. BUT my Mysql's version is 5.7.41.

Can you help me with this problem? Thank you.