"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]