When running the mysqldbcompare command as mentioned in the previous post you may get the following error:

[html]
ERROR: Query failed. 1142: SELECT command denied to user ‘user’@’10.10.10.10’ for table ‘proc’
[/html]

Essentially the user ‘user’ doesn’t have the correct permissions to ‘SELECT’ from the database. To fix update permissions from within MySQL:

[html]
grant all privileges on database.* to ‘root’@’10.10.10.10’ identified by ‘password’;
[/html]

[html]
flush privileges;
[/html]

Written by Matt Cooper
Hi, I'm Matt Cooper. I started this blog to pretty much act as a brain dump area for things I learn from day to day. You can contact me at: matt@matthewc424.sg-host.com.