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 command in > a script to make it automatic to insert records. > > Nestor :-) > > Nestor A. Florez > > > >>> Tobias Asplund <[EMAIL PROTECTED]> 10/15/2003 12:02:21 PM >>> > > > c:\>mysql mydb < myfile.sql > > ERROR 1044: Access denied for user: '@localhost' to database 'mydb' > > try mysql -u administrator mydb < myfile.sql > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]