How to install and use myql connector in Python

Question

I have a python program that executes mysql queries. I need a mysql connector for this purpose. How to download it and use it?

Answer 1

You can use pip to search if the connector is already installed using following code -

 $ pip search mysql-connector | grep --color mysql-connector-python

If it is not available then you can download it using following code -

$ pip install mysql-connector-python-rf

Once downloaded you can verify it by typing import mysql.connector. If there is no error displayed then you can use it.