Auth0 integration with MySql database - problems with user authentication

Hi.

I’m trying to integrate Auth0 with onprem MySQL database - when trying to test the login script under Database Connections > MySql > Custom Database > Database Action Scripts > Login > Save And Try I get the following messages:
“Access denied for user ‘root’@‘peu-a-ec1-0.outbound.auth0user.net’ (using password: YES)”
and
“Client does not support authentication protocol requested by server; consider upgrading MySQL client”
I am using MySql version 8 on the server.
I found information that this is due to a different authentication protocol.
I tried using both the mysql2 library and changing the authentication method on the server with the command:
alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘password’
nothing has changed unfortunately.

Hi @mikeymike,

Welcome to the Auth0 Community!

Did you flush privileges; after completing that command as instructed in this SO post:

Hi,

I tried it, it doesn’t help. As you can see in the screenshot the root user is using standard authorization
auth04

Have you tried creating a new user in your MySQL server?

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.