Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
Member Login
Site Notices
1/25/2018 7:38:29 AM
Posted: 3/1/2006 7:52:22 AM EST
Just trying to get a connection to setup poll surveys, message boards, etc.

I've tried several versions and methods and I still get...


Connection error:

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


I've got a green connection light on mysql admin software and everything is connected but still
not working with any software.

I know this is real general information but was wondering if anyone could help with a mysql noob, keeping it as simple as possible. All the websites I've found so far seem to be for advanced users.

Thanks!
Link Posted: 3/1/2006 7:53:33 AM EST
Check to see that the file /tmp/mysql.sock exists and that you have permissions to read and write to it.
Link Posted: 3/1/2006 7:56:46 AM EST
find / -name mysql.sock -exec ln -s '{}' /tmp/mysql.sock \;

h.gif
Link Posted: 3/1/2006 7:57:25 AM EST
Look in /etc/mysql/my.cnf or /etc/my.cnf to see where it should be. It will look like:

[client]
...
socket = /var/run/mysqld/mysqld.sock


[mysqld_safe]
...
socket = /var/run/mysqld/mysqld.sock


[mysqld]
...
socket = /var/run/mysqld/mysqld.sock


Make sure that all three point to the same file. Your settings could point to /tmp/mysql.sock instead.


The permissions on your /tmp directory should look like:

drwxrwxrwt  9 root root 192512 Mar  1 12:56 /tmp


To change them do:

chmod 777 /tmp
chmod +t /tmp


z

Link Posted: 3/1/2006 8:03:12 AM EST
Link Posted: 3/1/2006 8:28:47 AM EST
ok, i've made so many changes, i've uninstalled and removed any registry info on mysql and gonna start fresh.

First of all, is mysql-4.0.26 the only software I need? It's not the latest, but the forum software I have recommended 4.x.

Thanks
Link Posted: 3/1/2006 8:57:49 AM EST
I'm certainly no MySQL expert, but I feel your pain.
I could not justify the administrative overhead as my
needs were simple. I switched to SQLite, YMMV.
SQLite can replace MySQL for most purposes, but not all.
Link Posted: 3/1/2006 11:39:19 PM EST
Link Posted: 3/1/2006 11:40:14 PM EST
Top Top