{"id":3232,"date":"2014-10-19T22:33:30","date_gmt":"2014-10-20T06:33:30","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=3232"},"modified":"2024-01-06T07:00:19","modified_gmt":"2024-01-06T14:00:19","slug":"getting-started-mysql-python-connector","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/python-mysql\/getting-started-mysql-python-connector\/","title":{"rendered":"Getting Started with MySQL Connector\/Python"},"content":{"rendered":"\n

Summary<\/strong>: In this tutorial, you will learn about MySQL Connector\/Python which allows you to interact with MySQL databases from Python.<\/p>\n\n\n\n

Introduction to MySQL Connector\/Python<\/h2>\n\n\n\n

To interact with the MySQL database from Python, you need a database driver. MySQL Connector\/Python is a standardized database driver provided by MySQL.<\/p>\n\n\n

\n
\"Python<\/figure>\n<\/div>\n\n\n

MySQL Connector\/Python supports almost all features provided by MySQL. It allows you to convert the parameter’s value between Python and MySQL data types such as Python datetime and MySQL DATETIME<\/a><\/code>.<\/p>\n\n\n\n

MySQL Connector\/Python is designed specifically for MySQL. It supports all MySQL extensions such as LIMIT<\/a><\/code>\u00a0clause.<\/p>\n\n\n\n

MySQL Connector\/Python allows you to compress the data stream between Python and MySQL database server using protocol compression. It supports connections using TCP\/IP sockets and secure TCP\/IP connections using SSL.<\/p>\n\n\n\n

MySQL Connector\/Python is an API implemented using pure Python. It means that you don’t need to install any MySQL client library or any Python modules except the standard library.<\/p>\n\n\n\n

MySQL Connector\/Python versions<\/h2>\n\n\n\n

You will need to install the correct versions of Python, MySQL, and Connect\/Python. The following table illustrates the compatible versions of Connect\/Python, MySQL, and Python:<\/p>\n\n\n\n

Connector\/Python Version<\/th>MySQL Server Versions<\/th>Python Versions<\/th>Connector Status<\/th><\/tr><\/thead>
8.x Innovation<\/th>8.1, 8.0, 5.7, 5.6<\/td>3.12 (8.2.0), 3.11, 3.10, 3.9, 3.8<\/td>General Availability<\/td><\/tr>
8.0<\/th>8.0, 5.7, 5.6, 5.5<\/td>3.11, 3.10, 3.9, 3.8, 3.7, (3.6 before 8.0.29), (2.7 and 3.5 before 8.0.24)<\/td>General Availability<\/td><\/tr>
2.2 (continues as 8.0)<\/th>5.7, 5.6, 5.5<\/td>3.5, 3.4, 2.7<\/td>Developer Milestone, No releases<\/td><\/tr>
2.1<\/th>5.7, 5.6, 5.5<\/td>3.5, 3.4, 2.7, 2.6<\/td>General Availability<\/td><\/tr>
2.0<\/th>5.7, 5.6, 5.5<\/td>3.5, 3.4, 2.7, 2.6<\/td>GA, final release on 2016-10-26<\/td><\/tr>
1.2<\/th>5.7, 5.6, 5.5 (5.1, 5.0, 4.1)<\/td>3.4, 3.3, 3.2, 3.1, 2.7, 2.6<\/td>GA, final release on 2014-08-22<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Installing MySQL Connector\/Python<\/h2>\n\n\n\n

Prerequisites<\/h3>\n\n\n\n

Before installing MySQL Connector\/Python, you need to have:<\/p>\n\n\n\n

    \n
  • The Root or Administrator privileges to perform the installation.<\/li>\n\n\n\n
  • The Python 3.x installed on your system<\/li>\n<\/ul>\n\n\n\n

    Note that the MySQL Connector\/Python installation requires Python to be in the system’s PATH or it will fail.<\/p>\n\n\n\n

    Installation<\/h3>\n\n\n\n

    The MySQL Python Connector is available on pypi.org, therefore, you can install it using the pip<\/code> command.<\/p>\n\n\n\n

    First, open Command Prompt on Windows or Terminal on Unix-like systems.<\/p>\n\n\n\n

    Second, create a new directory such as pub<\/code> to store the project files:<\/p>\n\n\n

    mkdir pub<\/code><\/span><\/pre>\n\n\n
    Third, go inside the pub<\/code> directory:<\/p>\n\n\n
    cd pub<\/code><\/span><\/pre>\n\n\n
    Fourth, create a new virtual environment:<\/p>\n\n\n
    python -m venv venv<\/code><\/span><\/pre>\n\n\n
    Fifth, activate the new virtual environment:<\/p>\n\n\n
    venv\\scripts\\activate<\/code><\/span><\/pre>\n\n\n
    Sixth, install the mysql-connector-python<\/code> package:<\/p>\n\n\n
    pip install mysql-connector-python<\/code><\/span><\/pre>\n\n\n
    Seven, run the Python CLI:<\/p>\n\n\n
    python<\/code><\/span><\/pre>\n\n\n
    Eight, import the mysql connector:<\/p>\n\n\n
    import<\/span> mysql.connector<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
    Finally, display the help of the mysql.connector<\/code> package:<\/p>\n\n\n
    help<\/span>(mysql<\/span>.connector<\/span>)<\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
    If you see the following output, meaning that you have installed the mysql-connector-python<\/code> package successfully:<\/p>\n\n\n
    Help on package mysql.connector in mysql:\n\nNAME\n    mysql.connector - MySQL Connector\/Python - MySQL driver written in Python.\n...<\/code><\/span><\/pre>\n\n\n
    Finally, press Ctrl+C twice to exit Python.<\/p>\n\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Use MySQL Connector\/Python to interact with the MySQL databases.<\/li>\n<\/ul>\n
      \n\t
      \n\t\t
      Was this tutorial helpful? <\/div>\n\t\t
      \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
      \n\t\t
      \n\t\t\t
      <\/div>\n\t\t\t\n\t\t\t