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
Did not workd, I get an error
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: NO)
I can log in as -u administrator when I use the -p option. I need to
make it work
from command line because I am planning to put this command in
a script to make it automatic to insert
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
http://www.mysql.com/doc/en/Option_files.html
Check the example halfway down the page, it shows how you can supply a
password through your my.cnf file.
I can log in as -u administrator when I use the -p option. I need to
make it work
from command line because I am planning to put this
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
At 13:15 -0700 10/15/03, Nestor Florez wrote:
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
Yes, that's how it's supposed to work:
http://www.mysql.com/doc/en/mysql.html
mysql -uadministrator -upwd mydb
