File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

MySQL : Access denied for mysqldump

Manish Hatwalne
Ranch Hand

Joined: Sep 22, 2001
Posts: 2578

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
Manish Hatwalne
Ranch Hand

Joined: Sep 22, 2001
Posts: 2578

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:
subject: MySQL : Access denied for mysqldump
Similar Threads
Null pointer exception in con.createStatement();
Petclinic of Spring2.5.6 with MYSQL and GLASSFISH
MySQL user and password errors
Back of database
MySQL Error