Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 821
  • Last Modified:

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

0
mschneikert
Asked:
mschneikert
  • 3
  • 2
1 Solution
 
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you can use wildcards:
GRANT LOCK TABLES ON wikidb.* TO 'wikiuser'@'localhost';

Open in new window

0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now