Help with MySQL

jmitchell · 06-19-2003, 09:07 AM

I'm trying to start MySQL on my new Slackware 9 box. It's a fresh install.

The problem is everytime I try to run mysqld, it says it can not find the program. So, after doing a bunch of reading and web surfing, I tried safe_mysqld. This seems to work except as soon as it starts, it tells me it has stopped. So, I run ps x, and I think it is still running, but I'm not sure. When I try mysql -u root it gives me an error message that it can not connect through /var/lib/mysql/mysql.sock (I think that is it).

Other things I have tried include but are not limited to a multitude of mysqladmin commands. Most of these result in an error message of not being able to connect on port 3306 and it telling me to try pinging the server (mysqladmin ping) or telneting to the port. Neither work telneting gives me connection refused on port 3306.

Any thoughts or suggestions are much appreciated.

jharris · 06-19-2003, 09:38 AM

It sounds to me like MySQL isn't starting. This is usually due to something really silly that's normally logged in your error log. Have a read of http://www.linuxquestions.org/questi...t=hostname.err to find out how to find your error log for MySQL.

Post the results of anything you try back here and we'll take it from there.

HTH and welcome to LinuxQuestions

Jamie...

trickykid · 06-19-2003, 10:39 AM

An easy way to get mysql running off a fresh Slack install is to do this as root:

Code:

# mysql_install_db
# chown -R mysql.mysql /var/lib/mysql
# safe_mysqld &

jmitchell · 06-19-2003, 11:34 AM

The following is my error log from when I run safe_mysqld

030619 10:28:23 mysqld started
030619 10:28:23 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
030619 10:28:23 mysqld ended

jmitchell · 06-19-2003, 11:36 AM

Quote:

Originally posted by trickykid
An easy way to get mysql running off a fresh Slack install is to do this as root:

Code:

# mysql_install_db # chown -R mysql.mysql /var/lib/mysql # safe_mysqld &

Thank you very much this worked wonderfully.

MikeeX · 06-23-2003, 08:00 AM

This worked for me too. Thanks!

ed_thix · 06-29-2003, 06:15 AM

luckily i found this post, using the search function in this board, now mysql works for me too

bennethos · 10-28-2004, 03:38 PM

Seemed to fix the prob on my system as well, just needed to do a /etc/init.d/mysql restart

thx