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 password
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]' (Using password: YES) when trying
/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
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 error 1045: Access