Auth0 integration with MySql database - problems with user authentication


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’@‘’ (using password: YES)”
“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:


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

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.