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
/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
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
- 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