RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
ediately. "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> 18/01/2005 01:23 PM To "Tait Sanders" <[EMAIL PROTECTED]> cc Subject RE: mysqldump access denied error Check that the user has FILE privileges, given that a SELECT ... INTO OUTFILE sou

RE: mysqldump access denied error

2005-01-17 Thread Logan, David (SST - Adelaide)
From: Tait Sanders [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 January 2005 1:47 PM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: RE: mysqldump access denied error yes the user can see the databases with 'show databases;' I was thinking that there

RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
; <[EMAIL PROTECTED]> 18/01/2005 01:13 PM To "Tait Sanders" <[EMAIL PROTECTED]>, 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

RE: mysqldump access denied error

2005-01-17 Thread Logan, David (SST - Adelaide)
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 questi