On 6/5/02 at 19:53, [EMAIL PROTECTED] (Sven Bentlage) wrote: > on my box the following helped: > > (su to root) > chown -R mysql /usr/local/mysql/var (check if this is the path to > your > mysql var ) > (exit root) > > that should do it. > also check in the user and host table if a connection from localhost > is > allowed for the specific user..
Having looked, I have no /usr/local/mysql/var. The installation instructions (from Marc Liyanage's excellent website) were as follows (in part): "sudo chown -R mysql /usr/local/mysql/*" followed by: "sudo ./bin/safe_mysqld --user=mysql &" Also, how do I check the user/host table? Thanks for your help, Regards, Phil. > On Monday, May 6, 2002, at 07:42 PM, Phil Dobbin wrote: > > > Hi. > > > > I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation > > went fine (into /usr/local/) but now I'm having what I believe is a > > common permission problem. When trying to add a database I get the > > following error: > > > > [localhost:~] phil% mysql > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > mysql> create database CONTACT; > > ERROR 1044: Access denied for user: '@localhost' to database > 'CONTACT' > > mysql> > > > > I couldn't find anything in the archives so I wondered, could > somebody > > let me know the workaround I need to do on the permissions to get me > > started? > > > > Any help appreciated. > > > > Regards, > > > > Phil. > > > > > --------------------------------------------------------------------- > > 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 <mysql-unsubscribe- > > [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