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

Reply via email to