the other thing is make sure you don't have a space after -p and before your password
mysql -h localhost -u root -p mysql < did.query > did.out says ask for the password and start in the database mysql mysql -h localhost -u root -pmysql < did.query > did.out says the password is mysql and don't start in any database On Wednesday 26 March 2003 09:12, you wrote: > Create a .my.cnf file in your home directory with permissions set to 600. > In that file put the lines > [mysql] > user=root > password=mysql > > now you can enter: > mysql < did.query > did.out > > Marianadin, Didier wrote: > >Hi, > > > >I want to execute a simple query in batch mode in a mysql database. > >my OS : Unix (solaris 2.6) > > > >when I run this command : > >mysql -h localhost -u root -p mysql < did.query > did.out > > > >I'm always asked password even if I've already specified it in the > > previous command line (mysql) > >Enter password: > > > >How to avoid it ? > > > >Didier ([EMAIL PROTECTED]). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
