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]