Error 1251 at runtime using native connection to MySql

Board index FiveWin for Harbour/xHarbour Error 1251 at runtime using native connection to MySql

Posts: 130

Joined: Fri Jun 30, 2006 02:14 PM

Error 1251 at runtime using native connection to MySql
Posted: Mon Jul 25, 2022 04: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

cmsoft

Posts: 1344

Joined: Wed Nov 16, 2005 09:14 PM

Re: Error 1251 at runtime using native connection to MySql
Posted: Mon Jul 25, 2022 10:19 PM

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

Code (fw): Select all Collapse

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

Salu2
Cesar Gomez
https://www.bcnsoft.com.ar
https://www.pedidosbcn.com

max

Posts: 130

Joined: Fri Jun 30, 2006 02:14 PM

Re: Error 1251 at runtime using native connection to MySql
Posted: Tue Jul 26, 2022 07:14 AM

Ahora esta bien!
Gracias Cesar.
Saludos

FiveTech Support Forums

Continue the discussion