View Single Post
Old 26th March 2013, 16:44
researcher7 researcher7 is offline
Junior Member
Join Date: Mar 2013
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts

Originally Posted by roe74979 View Post
thank you for your response,

I had to follow cod 2, because I did not do step 12 of the instructions because I just wanted ISPconfig, and not the rest.

so I installed MYSQL as instructed via your code. now I get to the same step

MySQL charset [utf8]: <-- ENTER
and i'm now getting this error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2)
ERROR: Unable to load SQL-Dump into database table.
Edit: Could this have anything to do with the fact that i'm doing this remotely from school to my home PC?

It should not have anything to do with your connection, once you are connected successfully via ssh, your commands are running on the server you are connected to.

ISP Config configuration from that link needs mysql installed and running.
At this point it is either not running or needs to listen on all IPS.
Edit your /etc/mysql/my.cnf and comment out the following line.
bind-address =

Something like

nano /etc/mysql/my.cnf
And then make sure
#bind-address           =
Use Ctrl + O and then Enter to save, Ctrl + x to exit.

Restart mysql

/etc/init.d/mysql restart
Check if it is running/listening.

netstat -tap | grep mysql
ps aux | grep mysql | grep -v grep
Both should not return empty responses. If they did, then mysql is not running and we need to find out why.
Reply With Quote