Posted by NC on 09/22/06 16:41

laredotornado@zipmail.com wrote:
>
> I did a complete export from my MySQL 4.0 db and imported
> into MySQL 5.0. But I'm having a problem with the mysql.user
> table. From my old db, I have an entry in there, "remanr", but
> now when I type the username and password, I get this message ...
>
> [laredotornado@localhost therefillingstation]$ mysql -u remanr -p
> SA_REFILL
> Enter password:
> ERROR 1045 (28000): Access denied for user 'remanr'@'localhost'
> (using password: YES)
>
> I have tried the password several times, all with the same result.
> My suspicion is the migration is the problem. Any ideas?

Ideas for what? What happened or how to fix the problem? Since
no one but you has the data, no one will be able to tell you what
went wrong. As to fixing the problem, log in as an administrator
and run a GRANT query to give remanr the necessary privileges.
Reset the password if necessary...

Cheers,
NC

[Back to original message]