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.
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user