Just trying to get a connection to setup poll surveys, message boards, etc.
I've tried several versions and methods and I still get...
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.
Check to see that the file /tmp/mysql.sock exists and that you have permissions to read and write to it.
Look in /etc/mysql/my.cnf or /etc/my.cnf to see where it should be. It will look like:
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
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.
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.