the solution here is that my password contained metacharacters and therefore I needed to include escapes before eac metacharacter like such:
/usr/bin/mysqldump -u user -pg/#o/$ogle db > dbBackup.sql this did the trick. thanks all for your help tait -----Original Message----- From: Tait Sanders [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 January 2005 1:36 PM To: mysql@lists.mysql.com Subject: mysqldump access denied error I've put together a shell script that is simply - /usr/bin/mysqldump -u user -ppassword db > dbBackup.sql When I run this script I get the error "1045: Access denied for user ' [EMAIL PROTECTED]' (Using password: YES) when trying to connect" When I log into mysql - user#mysql -u user -p password - I connect fine. Does anyone have any suggestions?? thanks, tait tait sanders computer support technician element IT services information services gold coast campus griffith university 9726 australia e [EMAIL PROTECTED] p +61 07 555 28348 f +61 07 555 29003 ------------------------------------------------------- PRIVILEGED - PRIVATE AND CONFIDENTIAL This email and any files transmitted with it are intended solely for the use of the addressee(s) and may contain information which is confidential or privileged. If you receive this email and you are not the addressee(s) [or responsible for delivery of the email to the addressee(s)], please disregard the contents of the email, delete the email and notify the author immediately. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ForwardSourceID:NT00017DC6