Originally Posted by roe74979
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 = 127.0.0.1
And then make sure
#bind-address = 127.0.0.1
Use Ctrl + O and then Enter to save, Ctrl + x to exit.
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.