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.

We can put some efforts to search in internet, because there are lot of discussions
http://www.google.com.sg/#hl=en&sour...8b13d00076e224

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

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

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:
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.

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