I'm sure lots of you are probably experiencing this.. I googled around and found this, tried it out and it works perfect.. looks like the owner is incorrect on some of the files in /var/lib/mysql/mysql
They should be owned my the mysql user, not root.

just do this..

chown -R mysql /var/lib/mysql

then either chmod +x /etc/rc.d/rc.mysqld ( if its not already )

reboot.

or, to test it.. run: /usr/bin/mysqld_safe &

voila.


also --- you might have to run mysql_install_db .. not sure if I had to do that first..

It's also explained in /etc/rc.d/rc.mysqld script which say:

# Before you can run MySQL, you must have a database. To install an initial
# database, do this as root:
#
# su - mysql
# mysql_install_db
#
# Note that step one is becoming the mysql user. It's important to do this
# before making any changes to the database, or mysqld won't be able to write
# to it later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').

This is not needed. Just restart the service not the whole computer!

Well, those instructions are a little late.. I think if the install gives you the option of starting it automatically when you boot up, this should be done for you during the install. If someone is bright enough to edit the rc.mysqld script and read the instructions, then I think they are bright enough to chmod +x the script. I don't think it should be a startup option on the install if it's not going to work automatically. That's just my opinion.

and micxz, apparently you didn't read..

We're too late? You posted at " Today 05:58 AM" and we answered just two hours later.

or, to test it.. run: /usr/bin/mysqld_safe &

Is what you want and not rebooting.

[Moderator Edit: Please refrain from using abusive language].

What I meant by those instructions being late is.. after you tell Slackware ( in the install ) to start mysqld on boot up, but no tables have been created and it fails to start on bootup.. THAT is too late. Not his or your instructions..

The reason I said reboot is so that people can see that it will startup correctly from the init scripts at bootup. I *also* noted the option of just running /usr/bin/mysqld_safe & to show that it works that way as well. I personally, after adding new services to my system like to reboot and make sure everything starts like it should.

To bad your having such a hard time. You explain yourself much better in the last post I see what you mean now, no need to call names;

I thought we were pretty fast with trying to help.
I will not try to help you anymore.

xdrainox, I recommend you to re-read the rules you agreed when you signed to this forum: http://www.linuxquestions.org/rules.php

Mara,

poop.

micxz,

I apologize for calling you retarded. I was frustrated.

No harm done;
I apologize for my quick and stout post;
I understand how these things can be hard to explain;

Click my buddie Icon below? I will do the same;