On Wednesday, May 28, 2003, at 06:31 AM, Jon Haugsand wrote:
* [EMAIL PROTECTED]What the permissions/ownership be on my database directory?
I think is the cause of my problem of only being able to startup mysqld as 'root'.
On my system the mysqld deamon runs as mysql and files are owned by mysql.
-- Jon Haugsand, [EMAIL PROTECTED] http://www.norges-bank.no
How can I check that my 'mysql daemon' is running as user 'mysql' and not 'root'?
I have already done 'chown -R mysql /pathto/databases
It looks like you're using Apple Mail, so I'll assume you're on OS X.
Open '/Applications/Utilities/Process Viewer' and type mysql (or some combination) into the find box. It'll give you the user (mysqld is the one you're looking at).
There are other ways, but that's the easiest way if you're not interested in reading 'man ps'. If you are interested in sticking with the command line, here are a couple of ways you could check:
ps -au
ps -U httpd
and of course:
ps -au|grep mysqld (terminal screen will need to be wide for this, most likely)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
