Storing data using MySQL

MySQL is a freely available, open source Relational Database Management System (RDBMS).  In this example, we will read the planets data from the website and store it into a MySQL database.

Getting ready

You will need to have access to a MySQL database. You can install one locally installed, in the cloud, within a container.  I am using a locally installed MySQL server and have the root password set to mypassword. You will also need to install the MySQL python library.  You can do this with pip install mysql-connector-python.

1. The first thing to do is to connect to the database using the mysql command at the terminal:

# mysql -uroot -pmypassword
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark...