SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 03/12/2018, 06:28 PM   #1
sodraw
Little Clucker
 
Join Date: Jan 2013
Posts: 7
Reputation: 0
Default Error SQL error #2059

When I try to open the server i got this problem.
Quote:
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)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] (c) 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.
sodraw is offline   Reply With Quote
Old 03/12/2018, 06:43 PM   #2
Calisthenics
Huge Clucker
 
Join Date: May 2018
Posts: 422
Reputation: 69
Default Re: Error SQL error #2059

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
Calisthenics is offline   Reply With Quote
Old 03/12/2018, 07:18 PM   #3
sodraw
Little Clucker
 
Join Date: Jan 2013
Posts: 7
Reputation: 0
Default Re: Error SQL error #2059

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.
sodraw is offline   Reply With Quote
Old 03/12/2018, 08:06 PM   #4
Calisthenics
Huge Clucker
 
Join Date: May 2018
Posts: 422
Reputation: 69
Default Re: Error SQL error #2059

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?
Calisthenics is offline   Reply With Quote
Old 04/12/2018, 10:42 AM   #5
sodraw
Little Clucker
 
Join Date: Jan 2013
Posts: 7
Reputation: 0
Default Re: Error SQL error #2059

Installer XAMPP.
sodraw is offline   Reply With Quote
Old 04/12/2018, 11:40 AM   #6
Calisthenics
Huge Clucker
 
Join Date: May 2018
Posts: 422
Reputation: 69
Default Re: Error SQL error #2059

Look for \xampp\mysql\bin folder. my.ini is also located there according to their FAQs.
Calisthenics is offline   Reply With Quote
Old 04/12/2018, 12:21 PM   #7
sodraw
Little Clucker
 
Join Date: Jan 2013
Posts: 7
Reputation: 0
Default Re: Error SQL error #2059

Once I am trying to connect via cmd doesn't work after I entered my password I got the same problem.
sodraw is offline   Reply With Quote
Old 04/12/2018, 12:38 PM   #8
sodraw
Little Clucker
 
Join Date: Jan 2013
Posts: 7
Reputation: 0
Default Re: Error SQL error #2059

Sorry for 2x post but I found an easy solution for this problem. I installed wamp and everything goes fine.
sodraw is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[Ajuda] fatal error 107: too many error messages on one line Estou muito irritado já com isso NemesisBR Português/Portuguese 14 19/02/2018 01:00 AM
error 017: undefined symbol,fatal error 107: too many error messages on one line Slicebook Scripting Help 11 04/05/2014 09:30 PM
An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds.... rati555 Scripting Help 1 14/09/2012 08:45 PM
Registered plate stock error 'error 076: syntax error in the expression, or invalid function call' Deal-or-die Scripting Help 2 25/06/2012 04:12 PM
I get tagmismatch error, But i cant find any error error Swiftz Help Archive 1 16/04/2011 05:31 AM


All times are GMT. The time now is 06:56 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.