Error when starting mysql

peppie · 12-22-2003, 10:34 AM

Hi

I have installed the latest tar ball from slakeware mysql-4.0.17-i486-1.tgz

When staring the server is stopped after a few seconds:
root@node:/etc/rc.d# ./rc.mysqld start
root@node:/etc/rc.d# Starting mysqld daemon with databases from /var/lib/mysql
031222 16:33:06 mysqld ended

root@node:/etc/rc.d#

Is ther more needer beside this tarball?
I looked to find a log of mysql but not found here on the system.

Peppie

poison · 12-22-2003, 12:23 PM

hi...

#> su mysql
#> mysql_install_db

that should solve your problem ^^
btw .... the instructions are in /etc/rc.d/rc.mysqld
RTFS ^^

regards

trickykid · 12-22-2003, 01:37 PM

Dont forget after intalling the initial db's, to change permissions/ownerships like this:

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

And then attempt to start the mysql server.

Regards.

poison · 12-22-2003, 02:20 PM

trickykid->
vim `which mysql_install_db`

Code:

# Create database directories mysql & test
  if test ! -d $ldata; then mkdir $ldata; chmod 700 $ldata ; fi
  if test ! -d $ldata/mysql; then mkdir $ldata/mysql;  chmod 700 $ldata/mysql ; fi
  if test ! -d $ldata/test; then mkdir $ldata/test;  chmod 700 $ldata/test ; fi
  if test -w / -a ! -z "$user"; then
    chown $user $ldata $ldata/mysql $ldata/test;
  fi

thats why you su to mysql ^^
sorry *g*

trickykid · 12-22-2003, 02:22 PM

My bad, wasn't thinking when I posted as I've usually end up creating mine as root and change the permissions afterwards during initial setup..

poison · 12-22-2003, 02:26 PM

well, it doesn't hurt chown'ing a second time =)
but I have to stop beeing a wise guy =P
hihi ^^

buttersoft · 03-03-2004, 09:57 AM

#> su mysql

when I do this I get
$/root$

if I now type mysql_install_db

I get bash error command not found.

I notice too that in my shell where I am logged in as root, after typing su mysql, I am dumped out of a root shell and given a user prompt.

What on earth have I done wrong? And how do I get MySQL going?

Trying too hard!

MySQL is performing at last. Thanks for the help everyone.