title: MySQL Database schema comparison between PROD and UAT server
body: <p>I have to perform a MySQL DB schema comparison between PROD and UAT environment. Can anyone help me here on how to perform the same since I am doing this activity for the first time? I have found couple of articles online but those are for 2 tables in a specific DB or 2 tables in different DBs whereas in some article they say to buy a 3rd party tool. What I need here is <strong>comparison of DBs schema on 2 different servers(PROD and UAT)</strong> using SQL query or Linux shell script.</p>
  
  <p>Thanks in advance.</p>