LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-14-2002, 03:42 AM   #1
Ratclaws
Member
 
Registered: Sep 2001
Location: New York
Distribution: Slackware 8
Posts: 100

Rep: Reputation: 16
mysql cant start


cant seem to start mysql.

i get an error 2002. cant connect to local mysql server through socket '/var/run/mysql/mysql.sock' (111)

check that mysqld is running and the mysql.sock exists.

it does. in the correct place too. owned by user mysql.

i checked mysqld is not running.
didn't show up in ps -ef and couldn't telnet to 3306

/var/lib/mysql/ratclaws.err shows the following

/usr/libexec/mysqld cant find file ./mysql/host.frm error number 13
mysqld ended.

/var/lib/mysql/mysql/host.frm exists.

any ideas?
 
Old 05-14-2002, 05:20 AM   #2
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu
Posts: 1,532

Rep: Reputation: 132Reputation: 132
if you downloaded and installed the rpm you have to start it:
/usr/local/mysql/bin/safe_mysqld mysql &
i`m not sure about the path, check it. or did you load source?
cheers jens
 
Old 05-14-2002, 09:08 AM   #3
cathodion
Member
 
Registered: May 2002
Location: The Netherlands
Distribution: Fedora Core 2
Posts: 46

Rep: Reputation: 15
Lightbulb Safe_mysqld

U should start the mysql server like this:

# safe_mysqld -u mysql

That should work...
Cheerss,

CathodioN.
 
Old 05-15-2002, 12:40 AM   #4
Ratclaws
Member
 
Registered: Sep 2001
Location: New York
Distribution: Slackware 8
Posts: 100

Original Poster
Rep: Reputation: 16
Still not working

I tried the following

# /usr/bin/safe_mysqld mysql &

and

# safe_mysqld -u mysql &

they both came out with the following...

Started Mysql deamon with databases from /var/lib/mysql
020514 'current time' mysql ended

and the errorlog says the same error as i mentioned in the first post.
 
Old 05-15-2002, 12:42 AM   #5
Ratclaws
Member
 
Registered: Sep 2001
Location: New York
Distribution: Slackware 8
Posts: 100

Original Poster
Rep: Reputation: 16
sorry that was the errorno: 13

mysqld started
can't find file ./mysql/host.frm
mysqld ended
 
Old 05-15-2002, 02:56 AM   #6
cathodion
Member
 
Registered: May 2002
Location: The Netherlands
Distribution: Fedora Core 2
Posts: 46

Rep: Reputation: 15
I think there aint no mysql user on your system that would explain why it can't find the file in the home dir.

Try this:

# safe_mysqld -u root

If that one does work, you have to create a mysql user and rerun the statement with root replaced with mysql.

Good luck,

CathodioN
 
Old 05-15-2002, 07:53 AM   #7
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu
Posts: 1,532

Rep: Reputation: 132Reputation: 132
you can create users only when the daemon is running. if you downloaded the source version you have to run a command like 'mysql_install_db' or similar to create the 'mysql' table and so on. but i donīt know the exact command, it should be in the mysql manual.
cheers, jens
 
  


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
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 07:23 AM
mysql doesn't start devit Linux - General 12 05-21-2004 04:24 PM
MySql error 2002, Cannot start mysql djchris Linux - Software 5 04-13-2004 07:12 PM
Cannot start MySQL cisco_kidd20 Linux - Software 13 03-25-2004 11:04 AM
I can't get MySQL to start. Travis86 Linux - Software 5 11-07-2003 12:58 PM


All times are GMT -5. The time now is 06:31 PM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration