wget https://dev.mysql.com/get/Downloads/Connector-Python/mysql-connector-python-2.1.7.tar.gz
tar xf mysql-connector-python-2.1.7.tar.gz
cd mysql-connector-python-2.1.7
python setup.py build
python setup.py install
wget https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-utilities-1.6.5.tar.gz
tar xf mysql-utilities-1.6.5.tar.gz
cd mysql-utilities-1.6.5
python setup.py build
python setup.py install
mysql_config_editor set --login-path=instance-3306 --host=localhost --user=root --port=3306 --password
mysql_config_editor print --login-path=instance-3306
查看加密.jpg
mysqldbcompare --server1=instance-3306 testjeecg:test_test_jeecg --run-all-tests
显示.jpg
mysqldbcompare --server1=instance-3306 testjeecg:test_test_jeecg --run-all-tests --difftype=sql -vvv
--difftype=sql 选项生产差异的SQL语句,同时,使用 --show-reverse选项可以显示出双方的SQL语句
对比过程图.png