RE: mysqldump access denied error

[Tait Sanders]

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  t.sanders@stripped
p [phone]
f  [phone]

-------------------------------------------------------


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)" <david.logan@stripped> 
18/01/2005 01:13 PM

To
"Tait Sanders" <T.Sanders@stripped>, <[e-mail]>
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

[phone] - Work
[phone] - Mobile
[phone] - Fax


-----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 [phone]
f  [phone]

-------------------------------------------------------


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