Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    14

    Unanswered: Mysqldump Error 1044 access "dbname" when using lock tables

    mysqldump --user root --password="password" --opt dbname > c:\mysql\test.sql

    every time I will get the error 1044 access 'dbname' when using lock tables.

    I also tried -
    --add-locks
    -l

    to the statement above but still have same error

    Please Help

    Please and Thank You

  2. #2
    Join Date
    Feb 2004
    Posts
    14

    Re: Mysqldump Error 1044 access "dbname" when using lock tables

    Sorry, I have solve the thing on my own.

    Forget to grant the database the lock tables priv.

    Thank You

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •