File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes MySQL : Access denied for mysqldump Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL : Access denied for mysqldump" Watch "MySQL : Access denied for mysqldump" New topic
Author

MySQL : Access denied for mysqldump

Manish Hatwalne
Ranch Hand

Joined: Sep 22, 2001
Posts: 2581

When I try to execute mysqldump on my server, I get following error -

mysqldump: Got error: 1044: Access denied for user 'abc'@'localhost' to database 'xyz' when using LOCK TABLES

I have already doen fllowing to grant all to the user "abc" -

mysql> grant all on *.* to 'abc'@'localhost' identified by 'xxxx';
Query OK, 0 rows affected (0.26 sec)

What is causing this problem and how can I fix it?

- Manish
Martin Simons
Ranch Hand

Joined: Mar 02, 2006
Posts: 196
First I have to ask, are you providing the password on the command line, since according to your grant statement the user has one.

But more to the point, you should be asking this at the forums on www.mysql.org
Manish Hatwalne
Ranch Hand

Joined: Sep 22, 2001
Posts: 2581

Yes, i was providing password on command line. Never mind - I just got this working today by excecuting "flush privileges" after grant command.

- Manish
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL : Access denied for mysqldump