yes the user can see the databases with 'show databases;' I was thinking that there might be a permissions issue... but it doesn't seem so.
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. "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> 18/01/2005 01:13 PM To "Tait Sanders" <[EMAIL PROTECTED]>, <mysql@lists.mysql.com> cc Subject RE: mysqldump access denied error Hi Tait, Have you tried show databases to make sure that user can actually use that database? mysql>show databases; That will tell you if that user has access as it won't show up in the listing. They may well be able to log into mysql but can they actually access that database is more the question. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----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. ForwardSourceID:NT00017DC2
