LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware > Slackware - Installation
User Name
Password
Slackware - Installation This forum is for the discussion of installation issues with Slackware.

Notices

Reply
 
Search this Thread
Old 12-22-2003, 10:34 AM   #1
peppie
LQ Newbie
 
Registered: Dec 2003
Posts: 6

Rep: Reputation: 0
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
 
Old 12-22-2003, 12:23 PM   #2
poison
Member
 
Registered: Dec 2003
Location: Layer 7 =D
Distribution: Slackware, LFS, Rock Linux
Posts: 165

Rep: Reputation: 30
hi...

#> su mysql
#> mysql_install_db

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

regards
 
Old 12-22-2003, 01:37 PM   #3
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
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.
 
Old 12-22-2003, 02:20 PM   #4
poison
Member
 
Registered: Dec 2003
Location: Layer 7 =D
Distribution: Slackware, LFS, Rock Linux
Posts: 165

Rep: Reputation: 30
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*
 
Old 12-22-2003, 02:22 PM   #5
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
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..
 
Old 12-22-2003, 02:26 PM   #6
poison
Member
 
Registered: Dec 2003
Location: Layer 7 =D
Distribution: Slackware, LFS, Rock Linux
Posts: 165

Rep: Reputation: 30
well, it doesn't hurt chown'ing a second time =)
but I have to stop beeing a wise guy =P
hihi ^^
 
Old 03-03-2004, 09:57 AM   #7
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
#> 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.

Last edited by buttersoft; 03-04-2004 at 09:37 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 Yesterday 02:13 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 01:52 AM
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
Mysql error starting nepcw Linux - Software 2 03-25-2004 09:55 AM


All times are GMT -5. The time now is 03:20 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration