> The -p tells MySQL to ask for a password from you. I usually > alias mysql to mysql -p since I'm not about to start storing > passwords in files all over the joint, and I usually use > multiple different DB users.
Cleaner solution would be to put the option into the mysql startup file such as ~/.my.cnf. If you do not want to store the password and have it just ask you for it simply put something like follows: ---- [client] password ---- For more details and in depth explanation see: http://www.mysql.com/doc/O/p/Option_files.html Cheers, Dave. This e-mail and any attachments may be confidential or legally privileged. If you received this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your co-operation. Mercer Human Resource Consulting Limited is regulated by the Financial Services Authority and is a member of the General Insurance Standards Council. Registered in England No. 984275. Registered Office: Telford House, 14 Tothill Street, London SW1H 9NB -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug