Bug #90636 mysqldbcompare incompatible with mysql 8.0
Submitted: 25 Apr 2018 22:20 Modified: 25 Apr 2018 23:38
Reporter: Robert Jacob Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:1.6.5 OS:Any
Assigned to: CPU Architecture:Any

[25 Apr 2018 22:20] Robert Jacob
Description:
mysqldbcompare requires mysql.proc table which has been removed in version 8 of mysql

How to repeat:
[root@db2-au mysql]# mysqldbcompare --server1=root:pwd@localhost --skip-data-check --skip-row-count template:autosql
# WARNING: Using a password on the command line interface can be insecure.
# server1 on localhost: ... connected.
# Checking databases template and autosql on server1
#
ERROR: Query failed. 1146 (42S02): Table 'mysql.proc' doesn't exist

Suggested fix:
change all system table queries to use the information_schema views
[25 Apr 2018 23:38] MySQL Verification Team
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=83701.
[25 Jul 2018 16:40] Gayathri Jayaraman
Any fix for this to use the mysql utilities 1.6.5 with 8.0.11?
I am having the same error when using mysqldbcopy to copy databases between 2 mysql 8.0.11 instances. Appreciate any fix to this issue.
[22 Apr 2020 13:47] Gauravkumar Mishra
I am observing same issue with mysqldbcompare and mysqldbcopy.
An early fix will be appreciated.