mysql.sock: missing won't start
 

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.

mdk 9.1
mysql 4.0.11a-5.1mdk

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
Trying 65.103.35.246...
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
17:48:43
cerberus/home/chad # /etc/init.d/mysql start
Starting MySQL Server [ OK ]
17:48:45
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.

thanks.

You'll need to initialze your setup with the mysql setup scripts (usually path/to/install/scripts, it's in /usr/bin/mysql_install_db on my slack rig). This sets up the base permissions tables. You'll need to set some passwords as well. It's in the MySQL documentation and is required reading if you want to admin a mysql db.

i did all of the mysql_install, mysql_install_db, and it's still not coming up as running. it's all ways asking for the mysql.sock file and the hostname.err file. i have the hostname.err file, but no .sock file.

i've been fighting with this for over a week. maybe i should just stick with the postgresql. that's functioning as is, i just have to tweak it some for the apps that i want to use it with.

thank you though. i appreciate your time.

Doesn't anyone use the search feature of this forum?

The cause of this problem is usually running mysql_install_db as root. the correct way is to su to user mysql first, then run mysql_install_db. Try doing the following:

chown -R mysql.mysql /var/lib/mysql

If that doesn't work, then try searching for keywords like 'mysql', 'sock', etc.

Enjoy!
--- Cerbere