This repo contains practice code of accessing the MySQL DBMS using python. Resource for installing the MySQL server on your local machine can be found here.
You might also want to consider checking out this playlist by TheCodex to get started with connecting your MySQL server with python and writing some MySQL queries.
Check out my practice codes and feel free to recommend other resources to me too!