Originally Posted by cheezmode
The default mysql startup script is crap!!
in the rc.d directory back up the default rc.mysqld and write up a new one with the following contents:
mysql_safe --user root &
the restart teh mysql deamon
This is advice of the worst possible category.
Please ignore this "advice" since using the command "mysql_safe --user root &" is not resolving the issue properly. There is a reason for letting the mysql daemon not
run under the root account, and that reason is security
. If you don't care about security, that gives you no right to advise other people to toss any sense of security overboard as well.
The instructions in the header of the mysqld startup script (/etc/rc.d/rc.mysqld) are quite clear, and following them to the letter should get you a working mysql daemon.