LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-17-2011, 12:39 AM   #1
avnat
LQ Newbie
 
Registered: Nov 2009
Posts: 3

Rep: Reputation: 0
mysqld failed. the error was: initializing MySQL database.


I was trying to start the mysqld service and the above error appeared. Can somebody advise me step by step as to how the above can be rectified.
 
Click here to see the post LQ members have rated as the most helpful post in this thread.
Old 03-17-2011, 12:49 AM   #2
kirukan
Senior Member
 
Registered: Jun 2008
Location: Eelam
Distribution: Redhat, Solaris, Suse
Posts: 1,274

Rep: Reputation: 148Reputation: 148
We can put some efforts to search in internet, because there are lot of discussions
http://www.google.com.sg/#hl=en&sour...8b13d00076e224
 
Old 03-17-2011, 12:50 AM   #3
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

1. Please cut and paste the *full* error message
2. Please look in your MySql log: usually in /var/log/mysqld.log
3. Q: Did you just install MySQL? Or has it run successfully previously?

Thanx in advance .. PSM
 
2 members found this post helpful.
Old 03-18-2011, 12:37 AM   #4
avnat
LQ Newbie
 
Registered: Nov 2009
Posts: 3

Original Poster
Rep: Reputation: 0
mysqld failed

The error msg is as follows:

mysqld failed. The error was: initializing mYSQL database;
mkdir: cannot create directory '/userdatamysql': no such file or director
chmod: cannot access '/user/DATA/mysql': no such file or directory
mkdir: cannot create direcotr '/user/DATA/mysql/mysql': no such file or direcotry
chmod: cannot access '/user/DATA/mysql/mysql': No such file or directory
mkdir: cannot create directory '/user/DATA/mysql/test': no such file or directy

etc etc

omsta;;omg ,usq; suste, tab;es
110316 19:21.33 {warning} cmat create test fo;e/iser/DATA/mysql/anu.lower-test
/user/libexec/mysqld: can't change dir to '/user/DATA/mysql/' [errcode: 2]
110312 [ERROR] aborting
110316 [note] /usr/libexec/mysqld: shutdown complet
installion of system tables failed

esamine the logs in /user/Data/mysql for more information.
you can try and start the mysqld daemon with:
/usr/libexec/mysqld --skip-grant &
and use the command line tool
/usr/bin/mysql to connecttohe mysql database and look at the grant tables.

When i try looking in the log it says permission denied.

Yes i had installed sql earlier and was working with it. One day i was trying to combine some tables and create a new table however it seemed that it was not happening so i forced closure. from then on this trouble.

I will be really thankful if you can tell me step by step.

I will try and send a screenshot of the error msg. right now i am not able to do this.

Thanks a lot.

avnathan
 
Old 03-18-2011, 10:00 AM   #5
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

Sorry to make you manually type all that information - I thought you'd be able to just cut and paste.

Anyway, the information was important - thank you.

This is the problem:
Quote:
'/user/DATA/mysql/mysql': No such file or directory
It needs a directory "/user/DATA/mysql", and it's missing, or cannot be written to.

You will need to be "root" in order to start and stop mysql. And you will probably need to be "root" fix the "/user/DATA/mysql" problem, too.
 
1 members found this post helpful.
Old 03-18-2011, 11:58 PM   #6
avnat
LQ Newbie
 
Registered: Nov 2009
Posts: 3

Original Poster
Rep: Reputation: 0
mysqld failed

Hello,

Thanks. Can you tell me how to reinstall the mysql or what do i do to set this problem. I am logging in as root only.

Thanks once again.

avnathan
 
  


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
[SOLVED] MySQL Start Problem::::socket '/var/run/mysqld/mysqld.sock' (2) arun-linux Linux - Software 6 11-29-2012 06:56 AM
[SOLVED] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' Burningmace Linux - Server 5 09-06-2012 01:29 AM
[SOLVED] RT mysql database initializing error procfs Linux - Software 1 07-08-2012 12:12 PM
DBI Connect Failed:Access denied for user ''@'localhost' to database <database> error kaplan71 Linux - Software 3 06-05-2009 12:39 PM
mysqld error : 'mysql ended' anindyanuri Slackware 8 11-25-2005 11:14 PM


All times are GMT -5. The time now is 10:22 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