The interview assignment.
- Install MySQL.
- Create a user with a password:
CREATE USER 'username' IDENTIFIED BY 'password';
- Create a database:
CREATE DATABASE db_name;
- Grant the user all privileges to the database:
GRANT ALL ON db_name.* TO 'username';
- Write the connection details to
connection.json
. - Install modules if you don't have them already:
pip install glom mysql-connector-python
, - Run
main.py
. - You can view the data:
SELECT * FROM containers
,SELECT * FROM addresses