ok, i'm really starting to get frustrated with this. (great opening line, ha?)
this is my dilemma, i don't have a /var/lib/mysql/mysql.sock. i don't know if mysql will create on on it's own or not. yet when ever i try and start the thing up, it doesn't make that file.
i'll see if i can get all of the error messages for you here, if you need any others please ask.
first, trying to check the version.
cerberus/home/chad $ mysqladmin -h cerberus.cc version
mysqladmin: connect to server at 'cerberus.cc' failed
error: 'Can't connect to MySQL server on 'cerberus.cc' (110)'
Check that mysqld is running on cerberus.cc and that the port is 3306.
You can check this by doing 'telnet cerberus.cc 3306'
ok, now to see is the port is open.
telnet cerberus.cc 3306
telnet: Unable to connect to remote host: Connection timed out
now to see if the port is open in the firewall.
Starting nmap V. 3.00 ( www.insecure.org/nmap/
Interesting ports on (10.0.0.3):
(The 1588 ports scanned but not shown below are in state: filtered)
Port State Service
3306/tcp closed mysql
i don't know how to keep this thing open, if that is my problem, that would be an easy answer. oh, shorewall is the firewall. i had to scan from inside my network to get any thing here.
starting the server
cerberus/home/chad # /etc/init.d/mysql start
Starting MySQL Server [ OK ]
cerberus/home/chad # /etc/init.d/mysql status
mysqld is stopped
as you can see by the times, it's shutting down right away
i'm not sure if anything else is needed. i've gone through the manual, clicking on everything that could be relavent, yet to no avail. i've looked through 10 pages of google. i don't think that i'm entering the wrong search criteria, but if someone has a suggestion, i will give it a shot.