LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Slackware - Installation (https://www.linuxquestions.org/questions/slackware-installation-40/)
-   -   Error when starting mysql (https://www.linuxquestions.org/questions/slackware-installation-40/error-when-starting-mysql-128079/)

peppie 12-22-2003 10:34 AM
Error when starting mysql
 
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.


All times are GMT -5. The time now is 03:13 PM.