AMXX 1.9 - build 5294 mysql

[DeNeDe]

I'm using version 1.9 - build 5294 and i have problems using the admins sql feature or any other plugin that has sql feature Despite the fact all credentials are in order it doesn't want to connect. Ive tried both localhost and 127.0.0.1 for the host Using MariaDB 10.6 Should the mysql module be update or code re-written ?

[bigdaddy424]

Do you get this on the server console? Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open

[DeNeDe]

Ohh no I got [AMXX] SQL error: can't connect: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 0' this is for the admins the other plugins just say can't connect to the database

[bigdaddy424]

a quick google search leads to this https://stackoverflow.com/questions/3578147/mysql-error-2013-lost-connection-to-mysql-server-at-reading-initial-communic

[DeNeDe]

wow... jeeez thanks (sarcasm) of course ive tried that still didnt worked. idea is any other script i have work just fine using those credentials to connect to the database

[DeNeDe]

i've found the fix for it without any security risks ive looked in the database and the root account is for localhost but since in the config scripts we use 127.0.0.1 we just need to make another account for root for the host 127.0.0.1 (yes i use root under linux) yes i know..the 2 are the same, but not kinda (yes ive tried at first to use localhost instead of 127.0.0.1 in the configs but gave other errors)