Quote:
Originally Posted by sybella1
Some body mentioned on the user comments that mysqld to run, the directory (Slackware Users, from source)
/var/run/mysql/
must exists and owned by mysql user.
I ran exactly into this problem when I used the SuSE MySQL server RPM some years ago. That's why I said you need to dig out where the log files are kept, as the exact error messages are recorded in there. They will give you a clue as to what is wrong and why the server won't start. You don't need to do an strace -- that's too low-level for normal use. Errors phrased in a way like "Cannot open 'xxx.frm'" in the log file are indications of permission/ownership problems for instance. If you don't have the log file ready, I think it will not be possible for us here to offer any concrete help to your problem as there are just too many reasons the server will not start.
Quote the output of "mysqld --help", the section showing the variables. In particular, I would like to see the values for "datadir", "log", "log-error" and "socket". If possible, quote the entire section. It may help locate where your log files are kept.