Is the mysqld daemon set to run as root? do either ps -auxw | grep mysql or ps -ef | grep mysql
and see what mysqld is running as. You can set the server to run as a particular user regardless of what the file ownership of mysqld is. Also, have you installed the mysql database with mysql_install_db in the scripts directory? This installs the database 'mysql' which contains all user authentication. M -----Original Message----- From: Ben Ocean [mailto:[EMAIL PROTECTED]] Sent: 24 December 2001 17:40 To: [EMAIL PROTECTED] Subject: Re: Problems With New Installation I forgot to mention that /var/lib/mysql is owned by root and I'm in as root. I've also changed permission to mysql ownership of said directory with no luck. Any ideas? At 08:31 AM 12/24/01 -0800, you wrote: >Hi; >I've successfully installed mysql from source. However, I've run into a >problem with trying to create databases or users: > >mysql> create database cc_store; >ERROR 1006: Can't create database 'cc_store'. (errno: 13) > >Furthermore, I can't edit the root password. What fundamental step have I >missed? >TIA, >BenO > > > >--------------------------------------------------------------------- >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 --------------------------------------------------------------------- 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
