List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 12 2002 6:24pm
Subject:Re: Can access DBs when started w/ safe_mysql but not with mysqld ????
View as plain text  
Yes, exactly.
chown -R mysql  /usr/local/mysql
chown -R mysql  /var/lib/mysql

Of course you need to substitute the actual paths for the distribution 
and data directories.

David Kramer wrote:

>Ok thats what I was guessing, so I need to create a new user for the DB
>seperate from the root.  Do I " chown " the binaries and database files to
>my new user? Or Do the binaries always stay to root?
>
>Thanks much!
>
>DK
>
>-----Original Message-----
>From: Gerald Clark [mailto:gerald_clark@stripped]
>Sent: Friday, July 12, 2002 11:08 AM
>To: David Kramer
>Cc: mysql@stripped
>Subject: Re: Can access DBs when started w/ safe_mysql but not with
>mysqld????
>
>
>The mysql user should own the databases and files, not root.
>
>David Kramer wrote:
>
>>I am able to access all of the database instances that I have created when
>>starting Mysql with safe_mysql(as root user).  As soon as I start mysql any
>>other way, I keep getting the Access Denied Error.  Can root only access
>>
>DBs
>
>>under safe_mysql?  Im completely lost here....
>>
>>Thanks,
>>
>>DK
>>
>>David Kramer
>>Reflect.com
>>
>>
>>
>>---------------------------------------------------------------------
>>Before posting, please check:
>>  http://www.mysql.com/manual.php   (the manual)
>>  http://lists.mysql.com/           (the list archive)
>>
>>To request this thread, e-mail <mysql-thread114441@stripped>
>>To unsubscribe, e-mail
>>
><mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
>
>


Thread
Can access DBs when started w/ safe_mysql but not with mysqld????David Kramer12 Jul
  • Re: Can access DBs when started w/ safe_mysql but not with mysqld????Gerald Clark12 Jul
RE: Can access DBs when started w/ safe_mysql but not with mysqld????David Kramer12 Jul
  • Re: Can access DBs when started w/ safe_mysql but not with mysqld ????Gerald Clark12 Jul