Big problem with MYSQL

[Arthur Pemberton]

On 6/14/06, Karl Larsen <k5di at zianet.com> wrote:
>     I'm using FC4 and I installed a full mysql and it just will not
> work! And I have tried all that the ref manual offers and I think this
> problem is just RPM problem. MYSQL works in all ways except this critial
> step. It comes up when loading mysqld and it is fine until I want to
> show a DB. Then it fails totally!
>
> Here is an example:
>
> mysql> GRANT ALL ON test TO PUBLIC;
> ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'test'
> mysql>
>
> This is a problem NOT in the referance manual and I have no idea how to
> fix it. The dam problem is just a just a FC4 problem? I don't think so.
> I understand SQL well but this just defies understanding.
>
> Karl Larsen.

First step would

1) do the grant tables allow what you want to do? Easy solution would
be to move them and start fresh


2) check /var/log/message for any further error messages

-- 
To be updated...