[TheRedBull]

Hey i had the same error:
[multi1v1.smx] Could not connect: [2002]: Can't connect
to local MySQL server through socket '/tmp/mysql.sock' (2)

I fixed this by changing "localhost" to "127.0.0.1" in databases.cfg

I hope this works for you guys as well let me know

[404UserNotFound]

When I first got my dedi from OVH.com and then later switched from one dedicated server from OVH to two, I encountered similar issues.

The solution partly was installing necessary 32-bit libs as I used Ubuntu 12.04 64-bit. However, the issue kept persisting.

I do believe that if you haven't done so already, you should try restarting your dedicated server (provided you have a dedicated server) as that may help refresh things and help the dedicated server initialize MySQL properly.

As well, make sure MySQL has been started;

service mysqld start

Finally, make sure you have 32-bit libs if you're running a 64-bit OS;

$ sudo apt-get install lib32z1 lib32ncurses5 lib32bz2-1.0

The issue I encountered was SourceBans not starting because MySQL was not running and the appropriate sql sourcemod extension was unable to load. I really wish I had written down what I did to fix the issue as that may have helped you.

[asherkin]

Originally Posted by spot After reinstalling mysql, i get the same message. [multi1v1.smx] Could not connect: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Use '/var/run/mysqld/mysqld.sock' as the hostname rather than 'localhost'.

[aeleos]

Basically, I am pretty sure the problem is that you have sourcemod looking for the mysql socket in /tmp/mysql.sock and you have your mysql on your vps putting the socket in /var/run/mysqld/mysqld.sock. I am pretty sure the way to solve this is too make a symlink between so when sourcemod looks for the socket in /tmp/ it gets redirected to where mysql installed it in /var/. I think this command will fix the problem.

ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

[spot]

Originally Posted by aeleos Basically, I am pretty sure the problem is that you have sourcemod looking for the mysql socket in /tmp/mysql.sock and you have your mysql on your vps putting the socket in /var/run/mysqld/mysqld.sock. I am pretty sure the way to solve this is too make a symlink between so when sourcemod looks for the socket in /tmp/ it gets redirected to where mysql installed it in /var/. I think this command will fix the problem. ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

After i tryed your command i still get this error:
06/24/2015 - 09:20:06: [multi1v1.smx] Could not connect: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I even check that the /var/run/mysqld/mysqld.sock is there, and it is.

and btw:
lib32gcc1 is already the newest version.

[spot]

Originally Posted by TheRedBull Hey i had the same error: [multi1v1.smx] Could not connect: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I fixed this by changing "localhost" to "127.0.0.1" in databases.cfg I hope this works for you guys as well let me know

Tryed that, and i get this error then:
Could not connect: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111

[spot]

Anyone?

[DarkDeviL]

Originally Posted by spot Anyone?

If you don't remember the AlliedModders Rules, I suggest you re-read them:

Do not "bump" your threads. Bumping is posting simply to make the thread higher in the forum sort order.

This has been discussed somewhere else, where the result was no matter how long time you had no answers in, bumping was still not allowed.

Originally Posted by asherkin Use '/var/run/mysqld/mysqld.sock' as the hostname rather than 'localhost'.

What happened with asherkin's suggestion?

Also, what does this one give to you?

netstat -anp|grep -i mysql

[haeufi]

Originally Posted by jonitaikaponi Also, if you are running on Linux, try to install lib32z1. apt-get install lib32z1

This did the trick for me on debian wheezy. NOTE: You have to restart the server in order to apply the change, mapchange doesn´t reload extensions.

[spot]

Originally Posted by arne1288 If you don't remember the AlliedModders Rules, I suggest you re-read them: This has been discussed somewhere else, where the result was no matter how long time you had no answers in, bumping was still not allowed. - Sorry What happened with asherkin's suggestion? Also, what does this one give to you? netstat -anp|grep -i mysql

sudo netstat -anp|grep mysql
tcp 0 0 10.22.4.75306 0.0.0.0:* LISTEN 1090/mysqld
unix 2 [ ACC ] STREAM LISTENING 10961 1090/mysqld /var/run/mysqld/mysqld.sock

asherkin's suggestion:
Did not work, i can try again?

Originally Posted by haeufi This did the trick for me on debian wheezy. NOTE: You have to restart the server in order to apply the change, mapchange doesn´t reload extensions.

sudo apt-get install lib32z1
lib32z1 is already the newest version.
0 to upgrade, 0 to newly install, 0 to remove and 4 not to upgrade.