Error 1251 at runtime using native connection to MySql

Error 1251 at runtime using native connection to MySql

Postby max » 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
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

Postby cmsoft » Mon Jul 25, 2022 10:19 pm

Si tienes acceso root al servidor MySql, puedes probar poniendo la password asi:
Code: Select all  Expand view

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
cmsoft
 
Posts: 1257
Joined: Wed Nov 16, 2005 9:14 pm
Location: Mercedes - Bs As. Argentina

Re: Error 1251 at runtime using native connection to MySql

Postby max » Tue Jul 26, 2022 7:14 am

Ahora esta bien!
Gracias Cesar.
Saludos
User avatar
max
 
Posts: 128
Joined: Fri Jun 30, 2006 2:14 pm
Location: Ancona - Italy


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 71 guests