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
>>
>>
>
>
