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 -pmypasswordmysql: [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 4Server version: 5.7.19 MySQL Community Server (GPL)Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. ...

Get Python Web Scraping Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.