Howdy all,
I keep getting this error when I try to issue:
mysql mysql -u root -p
the same thing happens when I substitute any other database name, not just
mysql. I have another,nearly identical machine from which I copied the
contents of /var/lib/mysql/mysql/ . The permissions all appear to
where host='localhost' and user='root';
that's quite a bug there, and you should report it to the authors.
> Figured it just let root log in from anywhere.
almost. it lets root in from anywhere *except* localhost.
> Access denied for user: '@localhost
root can't access anything in mysql
anymore. When I do \s it shows the user as '[EMAIL PROTECTED]'. But when
I try to look at tables in mysql it thinks the user is only
'@localhost'. The error I get is:
Access denied for user: '@localhost' to database