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]

Reply via email to