MySQL - Confirm this isn't a TL issue

[davila]

Thinking this is a configuration / user problem with MySQL and not a TL problem. Looking for confirmation and suggestions. Thx!

I'm having troubles granting LOCK TABLES privileges to the testlink user (mysql). This is for our nightly backups.

$ mysqldump -u testlink -ptestlink testlink | gzip -9 > testbackup.gz
mysqldump: Got error: 1044: Access denied for user 'testlink'@'localhost' to database 'testlink' when using LOCK TABLES
$

mysql> use testlink
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> GRANT LOCK TABLES ON testlink TO testlink@localhost;
ERROR 1044 (42000): Access denied for user 'testlink'@'localhost' to database 'testlink'
mysql>