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? mysqlshow 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

RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
/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? mysqlshow databases; That will tell you if that user has access as it won't show

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 might

RE: mysqldump access denied error

2005-01-17 Thread Tait Sanders
- Adelaide) [EMAIL PROTECTED] 18/01/2005 01:23 PM To Tait Sanders [EMAIL PROTECTED] cc mysql@lists.mysql.com 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