I am having trouble running
mysqldump as the mysql root user. When I try to backup the
mysql table I get this error:
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES
Anyone seen that before? I've seen some references to my mysql and my mysqldump being different versions but when I run which they are in the same directory.
I am running MySQL 5.5.8.