Command line fails "mysql mydb < mufile.sql"

[Nestor Florez]

Help,

Guys I have done this before but it is not working for me when I try to
do some
inserts via a file from the command line
c:\>mysql mydb < myfile.sql
ERROR 1044: Access denied for user: '@localhost' to database 'mydb'

I am logged in as administrator on my W2K and I have granted ALL
privileges to 
administrator and it fails:
grant all privileges on mydb.* to administrator@localhost identified by
'pwd';

I even tried the following grants:
grant all privileges on mydb.* to administrator@'%' identified by
'pwd';
grant all privileges on mydb.* to '%@'%' identified by 'pwd';

No luck here.

Any ideas?


Thanks,

Nestor :-)


Nestor A. Florez