MySQL will not connect. - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL will not connect. (/showthread.php?tid=466587)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL will not connect. (/showthread.php?tid=466587)
MySQL will not connect. - Isolated - 28.09.2013
Hello,
I'm currently setting up a VPS for samp, with mysql and web hosting. However when I attempt to start SA:MP I get this:
Quote:
|
[18:45:45] >> mysql_ping( Connection handle: 1 ) [18:45:45] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection) [18:45:45] >> mysql_connect(localhost, mike, Server, ******) on port 3306 [18:45:45] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002) [18:45:45] [18:45:45] ** MySQL Debugging enabled (09/28/13) [18:45:45] [18:45:45] >> mysql_query_callback( Connection handle: 1 ) [18:45:45] >> mysql_query_callback( Connection handle: 1 ) [18:46:47] >> mysql_ping( Connection handle: 1 ) [18:46:47] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection) [18:46:47] >> mysql_connect(localhost, mike, Server, ******) on port 3306 [18:46:47] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002) [18:46:47] >> mysql_close( Connection handle: 1 ) [18:46:47] CMySQLHandler::~CMySQLHandler() - deconstructor called. [18:46:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) [18:46:47] CMySQLHandler:  isconnect() - You cannot call this function now. (Reason: Connection is dead)[18:46:47] Unloading Plugin [18:46:52] >> mysql_connect(localhost, mike, Server, ******) on port 3306 [18:46:52] CMySQLHandler::CMySQLHandler() - constructor called. [18:46:52] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "Server" | Username: "mike" [18:46:52] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002) [18:46:52] >> mysql_ping( Connection handle: 1 ) [18:46:52] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection) [18:46:52] >> mysql_connect(localhost, mike, Server, ******) on port 3306 [18:46:52] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002) [18:46:52] [18:46:52] ** MySQL Debugging enabled (09/28/13) [18:46:52] [18:46:52] >> mysql_query_callback( Connection handle: 1 ) [18:46:52] >> mysql_query_callback( Connection handle: 1 ) |
Re: MySQL will not connect. - Bit - 28.09.2013
Where are you hosting your MySQL database? In the VPS?
Re: MySQL will not connect. - Isolated - 28.09.2013
The MySQL database is installed into the VPS.
Re: MySQL will not connect. - Bit - 28.09.2013
You're using Debian system on your VPS? Try removing MySQL completely, and then re-install it on your VPS. Make sure to also ask the plugin developer on which version of MySQL do I install on the VPS.
Re: MySQL will not connect. - Isolated - 28.09.2013
I'm using CentOS 6, I've reinstalled MySQL a few times. Still not working, any other ideas?
Re: MySQL will not connect. - Bit - 28.09.2013
Try using the host name as localhost, and make sure you got the password right!
Re: MySQL will not connect. - Isolated - 28.09.2013
It's weird, I updated my MySQL plugin, now I get libmysqlclient_r.so.16 isn't found, even though it's installed. Fixed the above problem but now I have:
Quote:
|
[21:38:44] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) |
Re: MySQL will not connect. - MuLt1pl3x - 02.12.2014
CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)|
I am also having this issue, I know WHY i'm having it I just don't know where in the config to change it to fix it.
/var/run/mysqld/mysqld.sock is the wrong directory I need to change it to access /var/lib/mysqld/mysqld.sock
Re: MySQL will not connect. - Lordzy - 02.12.2014
Try creating a symbolic link, it might help:
Код:
ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock
Re: MySQL will not connect. - MuLt1pl3x - 02.12.2014
Quote:
|
Originally Posted by Lordzy
 Try creating a symbolic link, it might help:
Код:
ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock |
[08:46:04] >> mysql_connect( )
[08:46:04] CMySQLHandler::CMySQLHandler() - constructor called.
[08:46:04] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "pxgg" | Username: "root" ...
[08:46:04] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Error ID: 2002)
[08:46:04] >> mysql_query( Connection handle: 1 )
[08:46:04] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)
[08:46:04] >> mysql_store_result( Connection handle: 1 )
There has to be a config file that I can use to change the path it tries to connect through.