ait Sanders [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 January 2005 1:36 PM
To: mysql@lists.mysql.com
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
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
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
; <[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
36 PM
To: mysql@lists.mysql.com
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 '
[EMAIL PROTECTED]' (Usin
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 '
[EMAIL PROTECTED]' (Using password: YES) when trying to connect"
When I log into mysql - user#mysql -u user -p passwo
