R. Graham Street writes:
> Hi
> I'm new to Mysql and having a problem with permissions...
> I have a db called 'bugs', and would like everyone to have permission to
> it.
> I have records in host, db, and user tables indicating '%' for
> host,user and '' for password.
> However, when I connect as user 'daemon' i get the following error:
>
> ERROR 1044: Access denied for user: '@localhost' to database 'bugs'
>
> Here is a short version of my grant tables:
>
> USER
> +------------------+------------+----------+-------------+
> | Host | User | Password | Select_priv |
> +------------------+------------+----------+-------------+
> | localhost | root | | Y |
> | oscar.vninet.com | root | | Y |
> | localhost | | | N |
> | oscar.vninet.com | | | N |
> | % | % | | Y |
> | % | | | Y |
> | % | @localhost | | Y |
> +------------------+------------+----------+-------------+
>
> DB
> +------+---------+------------+-------------+
> | Host | Db | User | Select_priv |
> +------+---------+------------+-------------+
> | % | test | | Y |
> | % | test\_% | | Y |
> | % | % | % | Y |
> | % | bugs | @localhost | Y |
> +------+---------+------------+-------------+
>
> HOST
> +------+----+-------------+
> | Host | Db | Select_priv |
> +------+----+-------------+
> | % | % | Y |
> +------+----+-------------+
> 1 row in set (0.00 sec)
>
> Any help greatly appreciated. Thanks.
>
> Graham Street
Hi!
Erase all rows where your user is % and where your user is @localhost
!!!! These are errors.
Start server with -Sg and erase those rows with DELETE statemnt. Then
restart server. Define user guest@localhost, without password, and
give this user to all that you wish !!!
Sinisa
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == [EMAIL PROTECTED] |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Belgrade |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Serbia |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
