got error 1044 when dumping MySQL 5.0 BD

Hi i'm trying to backup a mySQL database and i'm getting the following message at the bottom of this DOS text. I'm using windows 2003 server and mysql 5.0.
---------------------------------------------------------------------------
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>cd program files\mysql\mysql server 5.0\bin\

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u wikiuser -p wikidb>F:\C
TLWIKIBACKUP\ctlwiki101008.sql
Enter password: ******
mysqldump: Got error: 1044: Access denied for user 'wikiuser'@'localhost' to dat
abase 'wikidb' when using LOCK TABLES

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u wikiuser -p wikidb>F:\C
TLWIKIBACKUP\ctlwiki101008.sql
Enter password: ******
mysqldump: Got error: 1044: Access denied for user 'wikiuser'@'localhost' to dat
abase 'wikidb' when using LOCK TABLES

C:\Program Files\MySQL\MySQL Server 5.0\bin>


-----------------------------


Any ideas how I can get around this LOCKED TABLES error so i can backup the database?

Many thanks experts

mschneikertAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you can use wildcards:
GRANT LOCK TABLES ON wikidb.* TO 'wikiuser'@'localhost';

Open in new window

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you need to grant the LOCK TABLE permissions to that login.
0
 
mschneikertAuthor Commented:
Thanks for this Angell - any ideas how i do this?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
http://dev.mysql.com/doc/refman/5.0/en/grant.html

GRANT LOCK TABLES ON <dbname>.<tablename> TO 'wikiuser'@'localhost';

Open in new window

0
 
mschneikertAuthor Commented:
ok my dbname is "wikidb" but i do not know the name of the table. Any idea how i find this out?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.