Python MySQL connection
Database Management using Python
Installing MySQL connection from Anaconda
Before this you must have MySQL database running and keep your connection userid and password with your database name ready.
We need to install MySQL connector to connect from Python to MySQL database.
Inside Anaconda goto
Environment at your left side navigational menu
Middle you can see
From Base root select
You will reach the Anaconda terminal where you can install any package . Just enter this line at the prompt to install MySQL connector.
This will install your MySQL connector by downloading packages from the internet. Now it is time to check the connection.
conda install -c anaconda mysql-connector-python
MySQL Connecting string