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.. Cheers, Sven 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