Hi Phil, first of all I don't think your mysqld is damaged. I would first check the following:
- where does mysqld looks for its datadir? - under which userid is mysqld supposed to run? - under which userid does mysqld runs? - does the user under which mysqld runs have write access to the datadir directory? - is the mysql database installed in the datadir directory? I have no knowledge about OS X or user management of OS X but it seems to me, that there is a misconfiguration of your mysql-setup. Check the mysql startscript, normaly it's pretty easy to change the datadir etc. in this. Greetings, Stefan -----Ursprungliche Nachricht----- Von: Phil Dobbin [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 23. Marz 2003 14:09 An: MySQL Betreff: Mysqld problem I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X 10.1.5 and have a startup script which confirms on boot that it has started but doesn't. I've tried starting manually from the CLI but no luck. I looked in localhost.err and found: 030323 9:48:21 /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13) 030323 9:48:22 /usr/local/mysql-3.23.51/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030323 9:48:22 /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13) 030323 09:48:22 mysqld ended According to the O'Reilly `MySQL Reference Manual' it seems that the daemon may have been damaged but offers no real clue as how to fix it. One other very odd aspect is that on OS X you create a mysql user in Sys Prefs and I noticed, upon reboot, that this user had disappeared from the pref panel. I re-created but to no avail. Any help at all on this would be gratefully appreciated. Regards, Phil. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]