RE: mysqldump access denied error

[Tait Sanders]

The user does have file privileges but - I just tried running the same 
script without the password included. Like the following:

"/usr/bin/mysqldump -u user -p db > dbBackup.sql" instead of 
"/usr/bin/mysqldump -u user -ppassword db > dbBackup.sql"

and this worked... so does anyone know what could be the problem with the 
password here? I really want to include the password in the script as I 
don't want to be prompted for it at say 3 in the morning when cron runs 
it.

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:23 PM

To
"Tait Sanders" <T.Sanders@stripped>
cc
<mysql@stripped>
Subject
RE: mysqldump access denied error






Check that the user has FILE privileges, given that a SELECT ... INTO
OUTFILE sounds awfully like a mysqldump :-
 
 The FILE privilege gives you permission to read and write files on the
server host using the LOAD DATA INFILE and SELECT ... INTO OUTFILE
statements. A user who has the FILE privilege can read any file on the
server host that is either world-readable or readable by the MySQL
server. (This implies the user can read any file in any database
directory, because the server can access any of those files.) The FILE
privilege also allows the user to create new files in any directory
where the MySQL server has write access. Existing files cannot be
overwritten. 
 
Regards

David Logan 
Database Administrator 
HP Managed Services 
148 Frome Street, 
Adelaide 5000 
Australia 

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

 

________________________________

From: Tait Sanders [mailto:T.Sanders@stripped] 
Sent: Tuesday, 18 January 2005 1:47 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@stripped
Subject: RE: mysqldump access denied error



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  [e-mail]
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" <[e-mail]>, <mysql@stripped> 
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@strippedu] 
Sent: Tuesday, 18 January 2005 1:36 PM
To: [e-mail]
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 


ForwardSourceID:NT00017DDA