Problem connecting to MySQL database:

KhabibAlmeidowski · 2021-06-22T22:32:19.630Z

I’m getting this when trying to connect to mysql-async:

[mysql-async] [ERROR] ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL cliente

This is what I have in server.cfg:

set mysql_connection_string "server=localhost;database=portugalrpdb;userid=root;password=abracadabra123"
start mysql-async

I’m trying to use MySQL Workbench instead of XAMPP, because that’s what I’m more used to, even tho I’m still a beginner.

What can I do?

kangoka · 2021-06-22T22:49:08.007Z

I was having this error once when I’m hosting on Linux and the only clue I remember is try to change the user password or create a new user but using the native mysql password, you can search on Google how to do it.

1GH0ST1 · 2021-06-23T04:32:52.880Z

try making a new user. Root and have the password blank

KhabibAlmeidowski · 2021-06-23T07:40:01.180Z

Fix. I uninstalled MySQL 8.0 and installed MariaDB.