Invoking Stored Procedures with Python

Make SQL Injection Vulnerabilities Harder to Exploit

Setting up a MySQL database with Docker

docker pull mysqldocker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=[your_password] -d mysql:latest
docker exec -it mysql bash
mysql -h localhost -u root -p
SELECT * FROM Users;

Creating Stored Procedures in MySQL

CALL get_email_addr("james", "password", @email);SELECT @email;

Invoking Stored Procedures with Python

pip install mysql-connector-python

EOF

Pythonista & Gopher | <OSCP> <CySA+> <Security+> | Part-time Cybersecurity Instructional Associate @ Fullstack Academy

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store