List:General Discussion« Previous MessageNext Message »
From:Tait Sanders Date:January 18 2005 4:44am
Subject:SOLVED:RE: mysqldump access denied error
View as plain text  
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:T.Sanders@stripped] 
Sent: Tuesday, 18 January 2005 1:36 PM
To: mysql@stripped
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 '
user@localhost' (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  t.sanders@stripped
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/mysql?unsub=1


ForwardSourceID:NT00017DC6 




Thread
mysqldump access denied errorTait Sanders18 Jan
RE: mysqldump access denied errorSST - Adelaide)18 Jan
  • RE: mysqldump access denied errorTait Sanders18 Jan
  • SOLVED:RE: mysqldump access denied errorTait Sanders18 Jan
RE: mysqldump access denied errorSST - Adelaide)18 Jan
  • RE: mysqldump access denied errorTait Sanders18 Jan