Trouble migrating from MySQL 4.0 to 5.0

Hi,

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?

Thanks for your help, - Dave

Re: Trouble migrating from MySQL 4.0 to 5.0

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