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

Sorry, I have solve the thing on my own.

Forget to grant the database the lock tables priv.

Thank You