[Qgis-user] Tell QGIS 3.16 to use "mysql_native_password" auth

[Victor Rodriguez]

Hello,

I'm having trouble connecting QGIS 3.16 to a MySQL Server v 5.7.32
(iirc). The PC runs Linux Mint 20.2, based on Ubuntu 20.04. The MySQL
client library available in this system is "libmysqlclient21", which is
based on MySQL 8. This version of MySQL changed the default
authentication from "mysql_native_password" to "caching_sha2_password".
That means that if you dont tell a MySQL8 client to use the older
authentication mechanism it will use the new one by default, which won't
work for a MySQL 5.7 server.

The error message I'm getting is:

'Extended error information:

MySQL connect failed for:
dbserver,host=10.10.4.4,port=3306,user=qgisuser,password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Error: Access denied for user 'qgisuser'@'10.0.0.3' (using password: NO)'

I have seen this error before using Python scripts which used old
libraries that did not allowed to set the auht mechanism to
"mysql_native_password" or did not read /etc/mysql/mysql.cnf for:

[client]
default-auth=mysql_native_password

How can I tell QGIS to use "mysql_native_password" as the authentication
mechanism?

Thank you.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210721/3f963bb0/attachment.html>