Hi Phil, ok, just to make sure your mysqld isn't damaged, what about replacing it with a new one (just binaries, not config and data)?
Stefan -----Ursprungliche Nachricht----- Von: Phil Dobbin [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 23. Marz 2003 16:21 An: Stefan Siefert; MySQL Betreff: Re: AW: Mysqld problem On 23/3/03 13:31, "Stefan Siefert" <[EMAIL PROTECTED]> wrote: > 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? Hi, Stefan. All things mysql are in their correct place (this has only just happened and I haven't changed anything in any directory pertaining to mysql). I basically cannot get mysqld to start in any shape or form, either from its system boot startup script or manually. Regards, Phil. > > -----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]