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 <
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
>
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 c
"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 i
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 re
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
privilege
