Trouble starting mysqld

koodoo · 08-15-2005, 08:55 AM

Hi,

I am currently working on Slackware 10.0
I am experiencing problems with starting the mysqld daemon.

Here's what I am doing :

Code:

koodoo@knapsacker:~$ su
Password:
root@knapsacker:/home/koodoo# sh /etc/rc.d/rc.mysqld start
root@knapsacker:/home/koodoo# Starting mysqld daemon with databases from /var/lib/mysql
050815 19:20:34  mysqld ended

This was my attempt to start the server. After the last line I get a cusor blinking at me i.e. I do not get back to the command prompt.

If now I try to start the client program I get the almost obvious error message :

Code:

koodoo@knapsacker:~$ mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
koodoo@knapsacker:~$

Thanks in anticipation.

zaert · 08-15-2005, 09:30 AM

At the first run, you must create the mysql database.
Read the /etc/rc.d/rc.mysqld to see how to do it.
su mysql
mysql_install_db

koodoo · 08-15-2005, 10:18 AM

Hi, Thanks Zaert,

I read the /etc/rc.d/rc.mysqld file and followed the steps and my mysqld daemon is working fine.

I have one more question though.
When I start the ssh daemon or for that matter any other daemon service, I usually get back to the command prompt i.e. :

Code:

koodoo@knapsacker:~$ su
Password:
root@knapsacker:/home/koodoo# sh /etc/rc.d/rc.sshd start
root@knapsacker:/home/koodoo#

But when I start the mysql daemon this does not happen, and the daemon occupies the terminal I used to invoke it.

Code:

koodoo@knapsacker:~$ su
Password:
root@knapsacker:/home/koodoo# sh /etc/rc.d/rc.mysqld start
root@knapsacker:/home/koodoo# Starting mysqld daemon with databases from /var/lib/mysql
<a cursor sits here>

Of course I can run it in the background, use nohup.
But my question is why does it not happen by default in the first place like for sshd.
(It's a daemon right ?)

I do not know much about this and any help will be appreciated.
Thanks again in anticipation.

zaert · 08-16-2005, 02:01 AM

After running /etc/rc.d/rc.mysql start, hit return to get back the console prompt.
mysql runs as a daemon, but its console message is not correctely finished.

koodoo · 08-16-2005, 10:09 AM

Hi, thanks again Zaert,

I hit the enter key and got my konsole prompt back.

Thanks a lot.