When migrating from the mysql to the mariadb connector, I found out, that when using the socket user identification from 10.5 the password is not ignored.
So an extra if block is needed to connect to the server.
using the mysql connector, this code will work:
But for the mariadb connector it must changed to:
When connect via socket auth, the password will be None, because it is not needed. But the mariadb python module can't handle it. The connect will fail with: