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:[EMAIL PROTECTED]] >Sent: Friday, July 12, 2002 11:08 AM >To: David Kramer >Cc: [EMAIL PROTECTED] >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 <[EMAIL PROTECTED]> >>To unsubscribe, e-mail >> ><[EMAIL PROTECTED]> > >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> > > --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
