mysql start problems.

compu73rg33k · 02-19-2005, 03:09 AM

I installed Slackware 10.1 and didn't do anything to mysql. When I ran /etc/rc.d/rc.mysql | start , I received this message

Code:

root@Suzzy:~# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
050219 03:05:16  mysqld ended

reddazz · 02-19-2005, 03:14 AM

You need to switch to root using the "su" command, then switch to the "mysql" user using the same command then run "mysql_install_db".

Artanicus · 02-19-2005, 03:16 AM

I quess the typos were just typos, and you actualy meant:
/etc/rc.d/rc.mysqld start
?

Anyways, It seems something goes wrong with the startup.. (doh) You realy should set a root password fpr mysqld before using it.. After that, it worked for me just great.

Another thing, I did a few tests, and I get the exactly same output that you had if I allready have mysqld running and attempt to start it again.. So, make sure it isnt running allready.. (;

compu73rg33k · 02-19-2005, 03:47 AM

Yeah I stopped it and tried starting it and that's what I got.

How do I switch to the user mysql while as root?

reddazz · 02-19-2005, 04:56 AM

#su mysql

compu73rg33k · 02-20-2005, 02:02 PM

Okay ran the mysql_install_db but I still am unable to start it.

reddazz · 02-20-2005, 02:18 PM

Well, thats usually how I get it to work. Maybe do a google search and you may get some other helpful tips.

compu73rg33k · 02-27-2005, 08:49 PM

Alright well I still have this problem and I really need to get it resolved becuase I'm starting to learn PHP and such.

I did a tail -f /var/lib/msyql/Suzzy.err and I received

Code:

050227 20:41:55  mysqld started
050227 20:41:55 Can't start server : Bind on unix socket: No such file or directory
050227 20:41:55 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ?
050227 20:41:55 Aborting

050227 20:41:55 /usr/libexec/mysqld: Shutdown Complete

050227 20:41:55  mysqld ended