Explain the steps for establishing MySQL connection with Python.

The steps for establishing MySQL connection with Python are as follows:

Step 1: To connect Python to MySQL, we need to install mysql-connector using 'pip' command on the command prompt (cmd). Do ensure that MySQL-connector is installed in the same folder as Python.

Step 2: Once the path is set, type the command as — python -m pip install mysql-connector or pip install mysql-connector-python. MySQL shall download and will be installed on our system. Now, we need to check whether it has been properly installed or not.

Step 3: To do this, type import mysql.connector in Python shell. If no error message gets displayed, this signifies that driver has been successfully installed.

Step 4: The next step to using MySQL in Python scripts is to make a connection to the database. All Python DB-API modules implement a function: conn = module_name.connect(host = "localhost", user = "root", passwd = "password", database = "database_name").

Step 5: Once the connection is established, create a cursor object using the cursor() method of the connection object, mycursor = conn.cursor().

Step 6: We can now execute SQL queries using the execute() method of the cursor object, mycursor.execute("SHOW DATABASES")

Step 7: If our query retrieves data, we can fetch the results using methods like fetchone(), fetchall(), or fetchmany() on the cursor object.

Step 8: If we make any changes to the database, then commit those changes using commit() on the connection object, conn.commit(). Finally, close the connection, mycursor.close().