FiveTech Software tech support forums

Posted: **Mon Jul 25, 2022 4:09 pm**

I have FWH 18.07, and works good from many years with connection to MS SQL server using 'fw_openadoconnect'.
Now (my first time) I am trying to connect to a mysql database (service mysql named 'MySql80') using native FWH connection 'fwconnect', with library libmysql.lib.
At runtime I get this error in a dialog, and the connection does not work:

1251
Client does not support authentication protocol requested by server; consider upgrading MySQL client

What does it mean? How con i solve?
Thank you.
Bye

Posted: **Mon Jul 25, 2022 10:19 pm**

Si tienes acceso root al servidor MySql, puedes probar poniendo la password asi:

Code: Select all | Expand


ALTER USER 'myuser'@'%' IDENTIFIED WITH mysql_native_password BY 'my_password';
flush privileges;

Puedes mirar este link que habla del tema
https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server

Posted: **Tue Jul 26, 2022 7:14 am**

Ahora esta bien!
Gracias Cesar.
Saludos

FiveTech Software tech support forums

Error 1251 at runtime using native connection to MySql

Error 1251 at runtime using native connection to MySql

Re: Error 1251 at runtime using native connection to MySql

Re: Error 1251 at runtime using native connection to MySql