mysqlcompare is a command line tool to compare two database schema's and retreive the difference in an sql file.
composer global require lloadout/mysqlcompare
Connection data can be defined in a connections.json file , to create the connection file you run the following command
mysqlcompare init
a connections.json
file will be created , specifying a source and target connection and an sqlfile to store the sql statements in.
If you connect through an ssh connection you specify user@host:port
in the ssh field of the json. Your password will be prompted, either for you user or your ssh key.
The execution of comparison is done via
mysqlcompare compare