search

brouznouf / fivem-mysql-async

MySql Async Library for FiveM
MIT License
111 stars 106 forks source link

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

Open Almeidowski opened 3 years ago

Almeidowski commented 3 years ago

Describe the bug 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 client

To Reproduce I'm using this in server.cfg:

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

I'm using MySQL Workbench, instead of XAMPP, because that's what I'm more used to, but I'm still a beginner. Expected behavior To connect to MySQL server. I don't know. I'm stil learning.

Screenshots / Logs image

Software:

Additional Information I'm not using ESX.

Almeidowski commented 3 years ago

Fix: I was with MySQL 8.0, I uninstalled it and installed MariaDB and it's now working.

ComplxPanduh commented 3 years ago

Yea depending on updates they release things like database sql software needs updating so you work with a lower version now it will run super slow at loading stuff

On Tue, 22 Jun 2021, 23:16 Almeidowski, @.***> wrote:

Fix: I was with MySQL 8.0, I uninstalled it and installed MariaDB and it's now working.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/brouznouf/fivem-mysql-async/issues/177#issuecomment-866373543, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALZKU25UNKH5W2HJC3Y3IRLTUEDTLANCNFSM47EQ25PA .