Error 1251 at runtime using native connection to MySql

Post Reply
User avatar
max
Posts: 128
Joined: Fri Jun 30, 2006 2:14 pm
Location: Ancona - Italy

Error 1251 at runtime using native connection to MySql

Post by max »

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
User avatar
cmsoft
Posts: 1297
Joined: Wed Nov 16, 2005 9:14 pm
Location: Mercedes - Bs As. Argentina
Been thanked: 2 times

Re: Error 1251 at runtime using native connection to MySql

Post by cmsoft »

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
User avatar
max
Posts: 128
Joined: Fri Jun 30, 2006 2:14 pm
Location: Ancona - Italy

Re: Error 1251 at runtime using native connection to MySql

Post by max »

Ahora esta bien!
Gracias Cesar.
Saludos
Post Reply