Greetings,
I have restored a complete set of MySQL databases (including the mysql 'system' database) from backup after upgrading my MacOSX 10.1 host to 10.3.
After installing MySQL onto the host and starting mysqld I did:
/usr/local/mysql/bin/mysql < /path/to/backup.sql
and this seems to have created all the necessary tables in:
/usr/local/mysql/data/
However, logging in is now an issue. If I try to log in with my existing credentials I get:
ERROR 1045: Access denied for user: '<any_user>@localhost' (Using password: YES)
where <any_user> is any of the users previously defined in my database. However, I can log in with the default 'root' account and a blank password, which I find a bit strange given that I thought MySQL kept all these credentials in its mysql system database.
Can anyone advise?