2
votes
1answer
773 views

When to use a MySQL socket and when to use a host:port?

Many applications allow me to connect to Mysql using a username, password host and port. Some allow me to configure a socket instead of the host:port. Is there any clear benefit of one over the ...
1
vote
3answers
2k views

ERROR 2002 MYSQL socket /tmp/mysql.sock

A have already read everything about this error but I coundn't solve the problem. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) I'm trying to install ...
-1
votes
1answer
353 views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

The IP address on my server recently was changed, and after the change, i performed a restart and when it came back online MySQL stopped working. I am running Debian 6. I type mysql -u username -p ...
1
vote
1answer
1k views

Setting up PHP 5.4 with MySQL to use Unix Sockets

I've compiled PHP 5.4.5 from source, and I've installed nginx 1.2.1 and mysql 5.1.63-0ubuntu0.11.04.1 from apt-get on my Ubuntu 11.04 LTS server. I installed nginx using this: add-apt-repository ...
0
votes
1answer
139 views

mysql socket issues

Whenever I try and run mysql I get the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I did some research and it looks to ...
1
vote
2answers
362 views

Performance: mysql socket vs. mysql remote

I'm running a couple of projects which consume a lot of MySQL power (10'000 qps in peaktimes)...now I'm wondering what would be the best setup in order to keep it fast and smooth even if the user ...
0
votes
3answers
284 views

How to connect with MySQL server if it won't connect via the socket?

I have an account on a shared server. I have jailshell access and also PhpMyAdmin. I want to run mysql commands via SSH but I'm getting an error: $ mysql -u mySqlUser -p mySqlPw Can't connect to ...
0
votes
1answer
146 views

MySQL Server Connection Socket Error

i just compiled MySQL 5.1 on SunOS 5.11 (i think xD) and now i have some problems. I am able to start the server via ./bin/mysqld_safe & and i can run the mysql* tool in /bin via Putty, however ...
0
votes
2answers
581 views

mysql error 2002 “cannot connect to socket”

I am having trouble with the server I'm running my trac on. I accidentally had the nightly back up going to the internal hard drive instead of the external. So it filled up, I erased the new files, ...