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
Error 1251 at runtime using native connection to MySql
- 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
Si tienes acceso root al servidor MySql, puedes probar poniendo la password asi:
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
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