"Nestor Florez" <Nflorez@stripped> wrote:
> 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?
>
You forgot to specify user name and password. You can do something like:
mysql -uadministrator -ppwd mydb < myfile.sql
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
