SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 13/05/2018, 11:49 AM   #1
vsskamal
Banned
 
Join Date: Apr 2018
Posts: 6
Reputation: 0
Default Can't connect to MySQL database in Linux server

i used MySQL_static.so and it worked fine but can't connect to database even database in localhost with correct credentials

[07:24:54] [MySQL] (Main Pipelines) Connecting to localhost...
[07:24:54] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host localhost - DB: ***** - User: *****
[07:24:54] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[07:24:54] [MySQL] Error number: 2002
vsskamal is offline   Reply With Quote
Old 13/05/2018, 12:36 PM   #2
RODELA
Big Clucker
 
RODELA's Avatar
 
Join Date: Oct 2017
Location: at mars
Posts: 105
Reputation: 23
Default Re: Can't connect to MySQL database in Linux server

Listen First import your .sql file on PHPMYADMIN(on VPS MYSQL)

Select a database > Import > Select .sql > Import.

Then goto your mysql > copy Username and pass.
Change the Script mysql Host to : 127.0.0.1.
Username/DB:
PASS:

Recompile your script and Start the server again.

Please +rep if you find this useful
RODELA is offline   Reply With Quote
Old 13/05/2018, 01:11 PM   #3
vsskamal
Banned
 
Join Date: Apr 2018
Posts: 6
Reputation: 0
Default Re: Can't connect to MySQL database in Linux server

I followed all things but still it cant connect same error
+rep for toturial
vsskamal 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
[Tutorial] How to connect to a MySQL database RIDE2DAY Tutorials 4 20/12/2017 06:57 AM
mysql can't connect database [S-G]Cypher Scripting Help 1 03/10/2015 01:34 PM
Server doesn't seem to connect to the MySQL database Jimmy0wns Scripting Help 11 13/02/2015 10:29 PM
Can't connect to mysql database.. Ox1gEN Scripting Help 45 28/08/2014 03:41 AM
MySQL won't connect to my database Rocky2k12 Server Support 5 17/04/2014 02:39 PM


All times are GMT. The time now is 02:58 PM.


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