MySQL server not starting
 

i was wondering.... I just got done installing mysql server from source and it won't start it just gives me this:

never had this problem. I am using slackware 9.0, where is the config file by the way, Its not in /etc

any help is appreciated.

A few questions:

How are you starting the server? I use mysqld_safe & and it works without a problem.

Also, did you set up root as a user? If not, try starting with mysqld_safe --user=mysql &

Finally give this a read.

The .err file (like markus.err if your hostname is markus) will contain valueable information that will help you to fix your problem!

can't find ./mysql/host.frm
 

hey thanks for the help... Ya i am trying to start it w/ "mysqld_safe &" and also "mysqld_safe -user-mysql &" but it doesn't go... I think the answer lies in what markus was saying. When I look into the .err file it reads:what is host.frm anyways...

I GOT IT
 

hey guys I got it. I did a little chowning and chgrping and it worked.

to be exact: chown root /usr/local/mysql
chown mysql /usr/local/mysql/var
chgrp mysql /usr/local/mysql

started it up and set my password and stuff is now running great. Thanks for your guys' help i would have never found out w/o ya.. Thanks marcos for the tip on the error message. I will have to remember that one. THANKS AGAIN.

this thread was really helpful - thanx!