[sodraw]

When I try to open the server i got this problem.

Quote:

SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [20:22:23] filterscripts = "" (string) [20:22:23] [20:22:23] Server Plugins [20:22:23] -------------- [20:22:23] Loading plugin: mysql [20:22:23] >> plugin.mysql: R39-3 successfully loaded. [20:22:23] Loaded. [20:22:23] Loading plugin: sscanf [20:22:23] [20:22:23] =============================== [20:22:23] sscanf plugin loaded. [20:22:23] Version: 2.8.1 [20:22:23] © 2012 Alex "Y_Less" Cole [20:22:23] =============================== [20:22:23] Loaded. [20:22:23] Loading plugin: streamer [20:22:23] Loaded. [20:22:23] Loading plugin: Whirlpool [20:22:23] [20:22:23] ================== [20:22:23] [20:22:23] Whirlpool loaded [20:22:23] [20:22:23] ================== [20:22:23] [20:22:23] Loaded. [20:22:23] Loading plugin: nativechecker [20:22:23] Loaded. [20:22:23] Loading plugin: crashdetect [20:22:23] CrashDetect plugin 4.19.4 [20:22:23] Loaded. [20:22:23] Loaded 6 plugins. [20:22:24] [20:22:24] Filterscripts [20:22:24] --------------- [20:22:24] Loaded 0 filterscripts. [20:22:24] [20:22:24] [20:22:24] [20:22:24] ======================================= [20:22:24] | | [20:22:24] | YSI version 3.09.0684 | [20:22:24] | By Alex "Y_Less" Cole | [20:22:24] | | [20:22:24] ======================================= [20:22:24] [20:22:24] [SQL] Connection to "localhost" failed! Please check the connection settings... [20:22:24] Number of vehicle models: 0

And SQL error says:

Quote:

[ERROR] CMySQLConnection::Connect - (error #2059) Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.

I lost 2 hours of my life searching on internet trying to solve this issue but got no clue.
I've tried to open the server into my PC. As I searched onto internet I understood something like this plugin should be implemented into mysql 8.x.x.

[Calisthenics]

PHP is not compatitible with caching_sha2_password method yet anyway. Connect to mysql server via command line and change your password:

pawn Code:

ALTER USER 'user'@'host' IDENTIFIED WITH mysql_native_password BY 'password';

Set in my.ini the authentication method and restart service again:

pawn Code:

[mysqld]
default_authentication_plugin = mysql_native_password

You can also pass configuration parameters when installing and initialize mysql like:

pawn Code:

> mysqld --install
> mysqld --initialize --default-authentication-plugin=mysql_native_password --secure-file-priv="..." 
> net start mysql

[sodraw]

Exactly the same thing i found on the internet and I don't know how to do it. If you gonna add few screenshots about how to do that exactly will be very useful.

[Calisthenics]

Find the path for mysql/bin folder. Run command prompt as administrator:

Code:

> cd path_to_folder\mysql\bin
> mysql -u user -p

Replace `user` with yours and enter the password when it asks for. As soon as you manage to login, execute:

Code:

ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Replace the keywords highlighted with blue color to match yours. After executing the above query, type exit to console twice. In mysql folder, you will find my.ini file. Open it and add

pawn Code:

default_authentication_plugin = mysql_native_password

under [mysqld] block. Restart mysql service and it should work.

Did you install mysql manually or using installer? Or did you install package such as XAAMP or WAMP?

[sodraw]

Installer XAMPP.

[Calisthenics]

Look for \xampp\mysql\bin folder. my.ini is also located there according to their FAQs.

[sodraw]

Once I am trying to connect via cmd doesn't work after I entered my password I got the same problem.

[sodraw]

Sorry for 2x post but I found an easy solution for this problem. I installed wamp and everything goes fine.