mysql help

Cyric · 10-07-2004, 11:46 PM

I am trying to start the mysql server in slackware 10. When I try to start it, I get fatal error: see the man on how to start mysqld as root!! I am trying to start it as root, and I cannot find the namual...lol...any help would be appreciated.

elluva · 10-08-2004, 04:02 AM

Strange, but you have to look for the docs on the mysql-site under development zone:
http://dev.mysql.com/doc/mysql/en/index.html

This the adress, I am sure it's in there and easy to find. I did it anyway but it is to long ago to remember

.

greetingz,
elluva

Cyric · 10-08-2004, 06:09 AM

ok, having a big problem, when trying to start mysql, I get this...

Code:

root@rogue-confederation:/# cd /usr ; /usr/bin/mysqld_safe &
[1] 6924
root@my-computer:/usr# Starting mysqld daemon with databases from /var/lib/mysql
041008 07:07:51  mysqld ended


[1]+  Done                    /usr/bin/mysqld_safe

Why does it end after it starts up? mysql is set to startup when I boot my computer, I get the same message then.

If I type mysqladmin version, I get this error:

Code:

root@rogue-confederation:/usr# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!

so I checked /var/run/mysql, and the folder is empty, what am I supposed to do about that?

apolinsky · 10-08-2004, 08:11 AM

If you read the contents of /etc/rc.d/rc.mysqld (or something like that...I am at work right now) you will see that before you start the daemon, some database files must be created. They list the commands that have to be executed to do it.

Cyric · 10-08-2004, 09:56 AM

yes, I ran mysql_install_db before I got those error messages.

Cyric · 10-08-2004, 06:32 PM

ok, got it started, it seems. Need to do further checkign to make sure everything is running correctly. In case anyone else runs into this same problem, here is what I did.

chown -R mysql /var/lib/mysql/*
chgrp daemon /var/lib/mysql/*

then I started it with this:

mysqld_safe &