First, make sure that you've set up the database according to the mySQL instructions
. From the second post that cosmicperl put up, it looks like that could be the problem. One of the things this procedure does is to set up the mysql table. NOTHING works without that.
Second, make sure the files in /var/lib/mysql are owned by mysql and not root. If they are owned by root, chown them so they are owned my mysql. Also check what is in /tmp. On my system, /var/mysql.sock is a link to /var/run/mysql/mysql.sock. Do a whereis mysql
and see if you can locate mysql.sock.
Third, check some of the solutions from the MySQL site
Finally, did you set a root password? The line you give (safe_mysqld --user=root) doesn't ask for one. If you DID set a root password, you need to use safe_mysqld --user=root -p
, in which case it is going to be tough to start mysql at boot time. You can reset root's