Big problem with MYSQL
brunson at brunson.com
Thu Jun 15 05:08:05 UTC 2006
Karl Larsen 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
> 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.
''@'localhost' indicates you're connecting as an unprivileged user,
probably with no password, connect as root (mysql -u root -p) and you
should have rights to do the grant.
More information about the users