Believe it or not I tried
mysql -p administrator -p pwd mydb < myfile.sql
and it would not worked, but when I got rid of the space it work
mysql -uadministrator -upwd mydb < myfile.sql
I did not think that the spaces after the '-u' and the '-p' matter
Thanks,
Nestor :-)
Nestor A. Florez
>>> Victoria Reznichenko <[EMAIL PROTECTED]> 10/15/2003
12:28:24 PM >>>
"Nestor Florez" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
