MySQL, Unable to create a UNIX socket (12)

Question

SQLSTATE[HY000] [2001] Can't create UNIX socket (12) 

On my local machine, my project works fine. As soon as I transferred my changes to the server, I get this error message.

The mysql log is completely empty.

Mysql config: my.cnf

However, another site that uses the same mysql server works fine.

---

Here's some more info: My vServer works with ubuntu 10.04 and has 2 GB of RAM.

 /root$ ps -le | grep mysqld 0 S 0 9502 1 0 85 0 - 1025 wait ? 00:00:00 mysqld_safe 4 S 109 9539 9502 0 76 0 - 77209 stext ? 00:01:02 mysqld /root$ ps -le | grep mysqld 0 S 0 9502 1 0 85 0 - 1025 wait ? 00:00:00 mysqld_safe 4 S 109 9539 9502 0 75 0 - 77209 stext ? 00:01:03 mysqld /root$ ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 20 file size (blocks, -f) unlimited pending signals (-i) 16382 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) unlimited virtual memory (kbytes, -v) unlimited file locks (-x) unlimited 

Maybe there is only viewing ram?

Answer 1

This is CR_SOCKET_CREATE_ERROR , an error caused by the client code.

12 is probably your errno client. What is error 12 on your system? For me, using the mysql perror command line perror , this is "OS 12 error code: memory cannot be allocated"