Hands-On Artificial Intelligence for IoT

The MySQL database engine

Though we can use SQLite for large databases, MySQL is generally preferred. In addition to being scalable for large databases, MySQL is also useful where data security is paramount. Before using MySQL, you will need to install the Python MySQL connector. There are many possible Python MySQL connectors such as, MySQLdb, PyMySQL, and MySQL; we will use mysql-connector-python.

In all three, after making a connection using the connect method, we define the cursor element and use the execute method to run different SQL queries. To install MySQL, we use the following:

pip install mysql-connector-python 

1. Now that the Python MySQL connector is installed, we can start a connection with the SQL server. Replace the host, ...