For this problem, you will need to write a program that will connect to a local MySQL database and use the MySQL Connector for python programming.

Write a python program that will prompt the user for a database schema name and report the number of tables, a list of table and the number of each record in each table. Design suggestions: Use two result sets One to hold the results of a "SHOW TABLES" command and one to hold a query of each table to determine the record count. Use a for loop to step through the first result set to display the first element of the tuple (the table name) and then query the table to find the number of records. Use the len() function on the result set to find the number of tuples.

please add comments to explain.