patternsqlMinor
mysqldbcompare SELECT command denied to user
Viewed 0 times
userdeniedmysqldbcompareselectcommand
Problem
I am trying to run mysqldbcompare to see the difference between two tables:
I get this error. I have already granted all privileges to users.
ERROR: Query failed. 1142 (42000): SELECT command denied to user 'server1'@'localhost' for table 'proc'
mysqldbcompare --server1=server1:2016@localhost --server2=server2:2016@localhost user:user --difftype=sql --run-all-testsI get this error. I have already granted all privileges to users.
ERROR: Query failed. 1142 (42000): SELECT command denied to user 'server1'@'localhost' for table 'proc'
Solution
You should enable the dbuser to have READ permissions to the proc table.
The process attempts to perform a SELECT statement on the 'proc'
table. The 'proc' table is a system table which retains the
procedures of all users on that mysql instance. On shared hosting,
allowing userA to see the procedures of userB, which would include
information about table structure, etc., would be considered breach of
security.All info found here
Or you can use the root user.
The process attempts to perform a SELECT statement on the 'proc'
table. The 'proc' table is a system table which retains the
procedures of all users on that mysql instance. On shared hosting,
allowing userA to see the procedures of userB, which would include
information about table structure, etc., would be considered breach of
security.All info found here
Or you can use the root user.
Context
StackExchange Database Administrators Q#136015, answer score: 2
Revisions (0)
No revisions yet.