fivem-mysql-async icon indicating copy to clipboard operation
fivem-mysql-async copied to clipboard

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

Open Almeidowski opened this issue 4 years ago • 2 comments

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:

  • OS: Windows 10
  • Version of the resource: I downloaded it just today so I assume it's the latest recommended.
  • Database Version: I don't know, but I downloaded it from MySQL website.

Additional Information I'm not using ESX.

Almeidowski avatar Jun 22 '21 21:06 Almeidowski

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

Almeidowski avatar Jun 22 '21 22:06 Almeidowski

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 .

ComplxPanduh avatar Jun 23 '21 11:06 ComplxPanduh