{"id":6151,"date":"2026-10-20T07:11:09","date_gmt":"2026-10-20T07:11:09","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=6151"},"modified":"2026-10-21T10:30:30","modified_gmt":"2026-10-21T10:30:30","slug":"python-mysql-connection","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/","title":{"rendered":"Python MySQL Connection"},"content":{"rendered":"

Python MySQL Connection Tutorial: Connect Python to MySQL With mysql.connector<\/b><\/strong><\/h1>\n

Almost every real application keeps its data in a database. A shop stores orders, a school stores marks, a company stores customers. Python can read and write that data, but it cannot talk to a database on its own. It needs a driver, a small library that speaks the language of the database server.<\/p>\n

For MySQL, the official driver is MySQL Connector\/Python. Once it is installed, a few lines of Python can connect to the server, create a database and a table, insert rows, read them back, change them and delete them. This is the base of data entry tools, reporting scripts, web back ends and data pipelines.<\/p>\n

In this tutorial, we follow ten clear steps: install the connector, check Python, import the module, create a connection, pick an editor, create a database, check it, create a table, check it, and insert rows. Then we cover select, update, delete, commit, rollback, placeholders that keep your data safe, error handling and a table of the common errors with their codes. Every program was run on a real database server, and the real output is shown.<\/p>\n

What You Need Before You Start?<\/h2>\n
    \n
  • Python 3 installed on your computer.<\/li>\n
  • A MySQL server that is running, and a MySQL account with a username and password. MySQL Workbench is a free visual tool that helps you check your account and see your tables.<\/li>\n
  • The connector library, which we install in step 1.<\/li>\n<\/ul>\n

    In every example, you will see your_user<\/code> and your_password<\/code>. Replace them with your own values. Never share a real password in a blog, a screenshot or a code repository.<\/p>\n

    Step 1: Install MySQL Connector\/Python<\/h2>\n

    The simplest way is pip, the Python package installer. Open the command prompt on Windows, or the terminal on Mac and Linux, and run:<\/p>\n

    \n
    terminal<\/div>\n
    pip install mysql-connector-python<\/pre>\n<\/div>\n
    You can also download the installer from the MySQL website. Pip is faster, works the same on every system, and is easy to update.<\/p>\n
    \"Step<\/figure>\n
    Step 2: Check That Python Runs in the Command Prompt<\/h2>\n
    Check that Python is set up properly by asking for its version. If you see a version number, you are ready. If the computer says the command is not found, Python is not on your path, and you need to fix that first.<\/p>\n
    \n
    terminal<\/div>\n
    python --version<\/pre>\n
    output<\/div>\n
    Python 3.13.16<\/pre>\n<\/div>\n
    Your version number may be different, and that is fine. On some Mac and Linux systems, the command is python3<\/code>.<\/p>\n
    \"Step<\/figure>\n
    Step 3: Import the Module<\/h2>\n
    The correct line is import mysql.connector<\/code>, and not just import mysql<\/code>.<\/p>\n
    \n
    python<\/div>\n
    import mysql.connector<\/pre>\n<\/div>\n
    If this line runs with no error, the connector is installed. If you see ModuleNotFoundError: No module named 'mysql'<\/code>, go back to step 1. You can also check the connector version:<\/p>\n
    \n
    python<\/div>\n
    import mysql.connector\r\nprint(mysql.connector.__version__)<\/pre>\n
    output<\/div>\n
    26.7.0<\/pre>\n<\/div>\n
    Your version will be different, since the library is updated often.<\/p>\n
    Step 4: Create a Connection<\/h2>\n
    To connect, call mysql.connector.connect<\/code> with the host (the computer where MySQL runs, usually localhost<\/code>), your username and your password.<\/p>\n
    \n
    python<\/div>\n
    import mysql.connector\r\n\r\nmydb = mysql.connector.connect(\r\n    host=\"localhost\",\r\n    user=\"your_user\",\r\n    password=\"your_password\"\r\n)\r\nprint(\"Connected:\", mydb.is_connected())<\/pre>\n
    output<\/div>\n
    Connected: True<\/pre>\n<\/div>\n
    \"Step<\/figure>\n
    \"Step<\/figure>\n
    Do not Use the Root Account<\/h3>\n
    Root can do anything on the server, including deleting every database. Make a separate user for your project, with only the rights it needs. Run this in MySQL Workbench or the mysql command line, as an administrator:<\/p>\n
    \n
    sql<\/div>\n
    CREATE USER 'your_user'@'localhost' IDENTIFIED BY 'your_password';\r\nGRANT ALL PRIVILEGES ON prwatech_demo.* TO 'your_user'@'localhost';\r\nFLUSH PRIVILEGES;<\/pre>\n<\/div>\n
    This user can work only on the database prwatech_demo<\/code> and nothing else.<\/p>\n
    Keep the Password Out of Your Code<\/h3>\n
    A password written inside a script ends up in screenshots, emails and shared folders. Read it from an environment variable instead.<\/p>\n
    \n
    python<\/div>\n
    import os\r\nimport mysql.connector\r\n\r\nmydb = mysql.connector.connect(\r\n    host=\"localhost\",\r\n    user=os.environ[\"MYSQL_USER\"],\r\n    password=os.environ[\"MYSQL_PASSWORD\"]\r\n)<\/pre>\n<\/div>\n
    You set the variables once in your system, and the code never contains the password. For the rest of this tutorial we show the simple form so the examples are easy to read.<\/p>\n
    Step 5: Choose a Code Editor and Run Your Script<\/h2>\n
    You do not need a particular editor. Use any one you like, such as VS Code, PyCharm, IDLE or Sublime Text. Save the code in a file, for example connect.py<\/code>, and run it from the terminal. This works in every editor and on every system.<\/p>\n
    \n
    terminal<\/div>\n
    python connect.py<\/pre>\n<\/div>\n
    In Sublime Text, Ctrl and B runs the file only after you choose Python as the build system. If you see nothing happen, that is usually the reason.<\/p>\n
    \"Step<\/figure>\n
    Step 6: Create a Database<\/h2>\n
    A database is a container for your tables. Use a cursor to send SQL commands to the server. The words IF NOT EXISTS<\/code> stop an error if you run the script twice.<\/p>\n
    \n
    python<\/div>\n
    cursor = mydb.cursor()\r\ncursor.execute(\"CREATE DATABASE IF NOT EXISTS prwatech_demo\")<\/pre>\n<\/div>\n
    There is no output, because the command only creates the database. The next step checks it.<\/p>\n
    \"Step<\/figure>\n
    Step 7: Check If the Database Exists<\/h2>\n
    List the databases your account can see, and look for yours.<\/p>\n
    \n
    python<\/div>\n
    cursor.execute(\"SHOW DATABASES\")\r\nnames = [row[0] for row in cursor]\r\nprint(\"prwatech_demo\" in names)\r\nprint(names)<\/pre>\n
    output<\/div>\n
    True\r\n['information_schema', 'prwatech_demo']<\/pre>\n<\/div>\n
    The first line prints True, so the database exists. The second line shows only the databases this account is allowed to see. An account with wider rights, such as root, will see more names, including the ones MySQL makes for its own use.<\/p>\n
    \"Step<\/figure>\n
    Step 8: Create a Table<\/h2>\n
    A table holds rows of data in fixed columns. To work inside your database, tell the connection which one to use. Setting the database<\/code> property on the connection does this. You can also pass database=<\/code> when you connect.<\/p>\n
    \n
    python<\/div>\n
    mydb.database = \"prwatech_demo\"\r\ncursor.execute(\r\n    \"CREATE TABLE students (\"\r\n    \"id INT AUTO_INCREMENT PRIMARY KEY, \"\r\n    \"name VARCHAR(50) NOT NULL, \"\r\n    \"course VARCHAR(50), \"\r\n    \"marks INT)\"\r\n)<\/pre>\n<\/div>\n
    This table has four columns.<\/p>\n
    \n\n\n\n\n\n\n\n\n
    Columns of the students table<\/caption>\n
    Column<\/th>\nType<\/th>\nWhat it means<\/th>\n<\/tr>\n<\/thead>\n
    id<\/th>\nINT, AUTO_INCREMENT, PRIMARY KEY<\/td>\nA number that MySQL fills in for each new row, and that identifies the row<\/td>\n<\/tr>\n
    name<\/th>\nVARCHAR(50), NOT NULL<\/td>\nText of up to 50 characters, and it cannot be empty<\/td>\n<\/tr>\n
    course<\/th>\nVARCHAR(50)<\/td>\nText of up to 50 characters<\/td>\n<\/tr>\n
    marks<\/th>\nINT<\/td>\nA whole number<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
    \"Step<\/figure>\n
    Step 9: Check If the Table Exists<\/h2>\n
    \n
    python<\/div>\n
    cursor.execute(\"SHOW TABLES\")\r\nprint([row[0] for row in cursor])\r\ncursor.execute(\"DESCRIBE students\")\r\nfor column in cursor:\r\n    print(column[0])<\/pre>\n
    output<\/div>\n
    ['students']\r\nid\r\nname\r\ncourse\r\nmarks<\/pre>\n<\/div>\n
    The first line shows the table is there. The second part lists its columns.<\/p>\n
    \"Step<\/figure>\n
    Step 10: Insert Into a Table<\/h2>\n
    To add a row, send an INSERT command. Put a %s<\/code> in the SQL for each value, and pass the values separately as a tuple. These are called placeholders. Do not build the SQL by joining text yourself. The reason is explained in the section on safety below.<\/p>\n
    \n
    python<\/div>\n
    sql = \"INSERT INTO students (name, course, marks) VALUES (%s, %s, %s)\"\r\ncursor.execute(sql, (\"Asha\", \"Python\", 82))\r\nmydb.commit()\r\nprint(cursor.rowcount, \"row inserted, id\", cursor.lastrowid)<\/pre>\n
    output<\/div>\n
    1 row inserted, id 1<\/pre>\n<\/div>\n
    Always Call commit<\/h3>\n
    MySQL keeps your changes in a waiting area until you call commit<\/code>. If you skip it, the insert is lost when the connection closes, and the table stays empty. This is the most common reason a beginner says my data is not showing.<\/p>\n
    Insert Many Rows at Once<\/h3>\n
    To add several rows, use executemany<\/code> with a list of tuples. It is faster and shorter than a loop.<\/p>\n
    \n
    python<\/div>\n
    rows = [(\"Ravi\", \"Python\", 74), (\"Meera\", \"Data Science\", 91), (\"Sam\", \"Python\", 65)]\r\ncursor.executemany(sql, rows)\r\nmydb.commit()\r\nprint(cursor.rowcount, \"rows inserted\")<\/pre>\n
    output<\/div>\n
    3 rows inserted<\/pre>\n<\/div>\n
    \"Step<\/figure>\n
    Read Data With SELECT<\/h2>\n
    Use SELECT to read your data back. The cursor then holds the result, and you fetch it with fetchall<\/code>, fetchone<\/code> or fetchmany<\/code>.<\/p>\n
    \n
    python<\/div>\n
    cursor.execute(\"SELECT * FROM students\")\r\nfor row in cursor.fetchall():\r\n    print(row)<\/pre>\n
    output<\/div>\n
    (1, 'Asha', 'Python', 82)\r\n(2, 'Ravi', 'Python', 74)\r\n(3, 'Meera', 'Data Science', 91)\r\n(4, 'Sam', 'Python', 65)<\/pre>\n<\/div>\n
    Each row comes back as a tuple. You can filter with WHERE and sort with ORDER BY, and pass the filter value as a placeholder:<\/p>\n
    \n
    python<\/div>\n
    cursor.execute(\"SELECT name, marks FROM students WHERE course = %s ORDER BY marks DESC\", (\"Python\",))\r\nprint(cursor.fetchall())\r\ncursor.execute(\"SELECT name FROM students WHERE id = %s\", (3,))\r\nprint(cursor.fetchone())<\/pre>\n
    output<\/div>\n
    [('Asha', 82), ('Ravi', 74), ('Sam', 65)]\r\n('Meera',)<\/pre>\n<\/div>\n
    A single value in a placeholder tuple needs a trailing comma, such as (\"Python\",)<\/code>. Without the comma, Python sees plain brackets and not a tuple. The method fetchone<\/code> returns one row, and None<\/code> when there are no more.<\/p>\n
    Update and Delete Rows<\/h2>\n
    \n
    python<\/div>\n
    cursor.execute(\"UPDATE students SET marks = %s WHERE name = %s\", (88, \"Ravi\"))\r\nmydb.commit()\r\nprint(cursor.rowcount, \"row updated\")\r\n\r\ncursor.execute(\"DELETE FROM students WHERE name = %s\", (\"Sam\",))\r\nmydb.commit()\r\nprint(cursor.rowcount, \"row deleted\")\r\n\r\ncursor.execute(\"SELECT COUNT(*), AVG(marks) FROM students\")\r\nprint(cursor.fetchone())<\/pre>\n
    output<\/div>\n
    1 row updated\r\n1 row deleted\r\n(3, Decimal('87.0000'))<\/pre>\n<\/div>\n
    Always include a WHERE clause on an update or a delete. Without it, the command changes or removes every row in the table. The rowcount<\/code> tells you how many rows were affected, which is a quick check that the command did what you meant.<\/p>\n
    Rollback: Undo a Mistake<\/h2>\n
    Until you call commit<\/code>, you can undo your changes with rollback<\/code>. Here we delete every row by accident, check the count, and then undo it.<\/p>\n
    \n
    python<\/div>\n
    cursor.execute(\"DELETE FROM students\")\r\nprint(cursor.rowcount, \"rows deleted, not saved yet\")\r\nmydb.rollback()\r\ncursor.execute(\"SELECT COUNT(*) FROM students\")\r\nprint(cursor.fetchone()[0], \"rows still there after rollback\")<\/pre>\n
    output<\/div>\n
    3 rows deleted, not saved yet\r\n3 rows still there after rollback<\/pre>\n<\/div>\n
    Why You Must Use Placeholders<\/h2>\n
    If you build SQL by joining text, a user can type something that changes the meaning of your command. This attack is called SQL injection, and it is one of the most common ways websites are broken into. Placeholders send the value separately from the command, so the database treats it only as data.<\/p>\n
    \n
    python<\/div>\n
    bad_name = \"x' OR '1'='1\"\r\ncursor.execute(\"SELECT * FROM students WHERE name = %s\", (bad_name,))\r\nprint(\"Rows found with the tricky text:\", len(cursor.fetchall()))<\/pre>\n
    output<\/div>\n
    Rows found with the tricky text: 0<\/pre>\n<\/div>\n
    The tricky text is treated as a plain name, so nothing matches. If the SQL had been built with an f string, the same text would have matched every row in the table.<\/p>\n
    Handling Errors<\/h2>\n
    Connections and queries fail often, because the server is off, the password is wrong, or a table is missing. Catch the Error<\/code> class from the connector, and read its errno<\/code> and msg<\/code>.<\/p>\n
    \n
    python<\/div>\n
    from mysql.connector import Error\r\n\r\ntry:\r\n    cursor.execute(\"SELECT * FROM missing_table\")\r\nexcept Error as e:\r\n    print(\"Error:\", e.errno, e.msg)\r\n\r\ntry:\r\n    bad = mysql.connector.connect(host=\"localhost\", user=\"your_user\", password=\"wrong_password\")\r\nexcept Error as e:\r\n    print(\"Connection failed:\", e.errno)<\/pre>\n
    output<\/div>\n
    Error: 1146 Table 'prwatech_demo.missing_table' doesn't exist\r\nConnection failed: 1045<\/pre>\n<\/div>\n
    These are the errors you will meet most often.<\/p>\n
    \n\n\n\n\n\n\n\n\n\n\n
    Common MySQL error codes<\/caption>\n
    Code<\/th>\nMeaning<\/th>\nWhat to check<\/th>\n<\/tr>\n<\/thead>\n
    1045<\/th>\nAccess denied for the user<\/td>\nThe username or password is wrong<\/td>\n<\/tr>\n
    2003<\/th>\nCannot connect to the MySQL server<\/td>\nThe server is not running, or the host or port is wrong<\/td>\n<\/tr>\n
    1049<\/th>\nUnknown database<\/td>\nThe database name is misspelt, or it was never created<\/td>\n<\/tr>\n
    1146<\/th>\nTable does not exist<\/td>\nThe table name is wrong, or you are in the wrong database<\/td>\n<\/tr>\n
    1048<\/th>\nA column cannot be null<\/td>\nA required value is missing from your insert<\/td>\n<\/tr>\n
    1064<\/th>\nError in your SQL syntax<\/td>\nA typo in the SQL, such as SELEC for SELECT<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
    The wording of a message can differ a little between MySQL versions, but the code number stays the same.<\/p>\n
    Close the Connection<\/h2>\n
    When you finish, close the cursor and the connection. This frees the resources on the server. Many servers allow only a limited number of connections, so leaving them open can block other users.<\/p>\n
    \n
    python<\/div>\n
    cursor.close()\r\nmydb.close()\r\nprint(\"Connected:\", mydb.is_connected())<\/pre>\n
    output<\/div>\n
    Connected: False<\/pre>\n<\/div>\n
    To make sure it always happens, even after an error, put the close calls in a finally<\/code> block. Our exception handling tutorial explains how.<\/p>\n
    Common Mistakes When Connecting Python to MySQL<\/h2>\n
      \n
    • Writing import mysql<\/code>.<\/strong> The module is mysql.connector<\/code>.<\/li>\n
    • Forgetting commit.<\/strong> Your inserts, updates and deletes are not saved until you call it.<\/li>\n
    • Using the root account.<\/strong> Create a user with limited rights.<\/li>\n
    • Building SQL with an f string or plus signs.<\/strong> Use placeholders.<\/li>\n
    • Leaving out WHERE.<\/strong> An update or delete without it hits every row.<\/li>\n
    • Forgetting the comma in a one value tuple.<\/strong> Write (value,)<\/code> and not (value)<\/code>.<\/li>\n
    • Putting the password in the code.<\/strong> Use an environment variable.<\/li>\n
    • Never closing the connection.<\/strong> Close it, or use a finally<\/code> block.<\/li>\n<\/ul>\n
      Quick Reference<\/h2>\n
      \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
      MySQL connector quick reference<\/caption>\n
      Task<\/th>\nCode<\/th>\n<\/tr>\n<\/thead>\n
      Install the connector<\/th>\npip install mysql-connector-python<\/td>\n<\/tr>\n
      Import it<\/th>\nimport mysql.connector<\/td>\n<\/tr>\n
      Connect<\/th>\nmysql.connector.connect(host=, user=, password=)<\/td>\n<\/tr>\n
      Make a cursor<\/th>\ncursor = mydb.cursor()<\/td>\n<\/tr>\n
      Run SQL<\/th>\ncursor.execute(sql, values)<\/td>\n<\/tr>\n
      Run many<\/th>\ncursor.executemany(sql, list_of_tuples)<\/td>\n<\/tr>\n
      Read results<\/th>\ncursor.fetchall(), cursor.fetchone()<\/td>\n<\/tr>\n
      Save changes<\/th>\nmydb.commit()<\/td>\n<\/tr>\n
      Undo changes<\/th>\nmydb.rollback()<\/td>\n<\/tr>\n
      Close<\/th>\ncursor.close() and mydb.close()<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
      Complete Script to Run Yourself<\/h2>\n
      Here is the full script used to produce every output on this page. Change your_user<\/code> and your_password<\/code> at the top, and run it with Python 3. It creates a database called prwatech_demo<\/code>, so it will not touch your other data. The script drops and rebuilds the students table each time, so run it only on a practice database.<\/p>\n
      \n
      python<\/div>\n
      import mysql.connector\r\nfrom mysql.connector import Error\r\n\r\n# Change these three values to match your own MySQL account\r\nHOST = \"localhost\"\r\nUSER = \"your_user\"\r\nPASSWORD = \"your_password\"\r\n\r\n# 1. Connect to the MySQL server\r\nmydb = mysql.connector.connect(host=HOST, user=USER, password=PASSWORD)\r\nprint(\"Connected:\", mydb.is_connected())\r\nprint(mysql.connector.__version__)\r\n\r\n# 2. Create a database, only if it does not exist yet\r\ncursor = mydb.cursor()\r\ncursor.execute(\"CREATE DATABASE IF NOT EXISTS prwatech_demo\")\r\n\r\n# 3. Check that the database exists\r\ncursor.execute(\"SHOW DATABASES\")\r\nnames = [row[0] for row in cursor]\r\nprint(\"prwatech_demo\" in names)\r\nprint(names)\r\n\r\n# 4. Use that database and create a table\r\nmydb.database = \"prwatech_demo\"\r\ncursor.execute(\"DROP TABLE IF EXISTS students\")\r\ncursor.execute(\r\n    \"CREATE TABLE students (\"\r\n    \"id INT AUTO_INCREMENT PRIMARY KEY, \"\r\n    \"name VARCHAR(50) NOT NULL, \"\r\n    \"course VARCHAR(50), \"\r\n    \"marks INT)\"\r\n)\r\n\r\n# 5. Check that the table exists\r\ncursor.execute(\"SHOW TABLES\")\r\nprint([row[0] for row in cursor])\r\ncursor.execute(\"DESCRIBE students\")\r\nfor column in cursor:\r\n    print(column[0])\r\n\r\n# 6. Insert one row, with placeholders\r\nsql = \"INSERT INTO students (name, course, marks) VALUES (%s, %s, %s)\"\r\ncursor.execute(sql, (\"Asha\", \"Python\", 82))\r\nmydb.commit()\r\nprint(cursor.rowcount, \"row inserted, id\", cursor.lastrowid)\r\n\r\n# 7. Insert many rows at once\r\nrows = [(\"Ravi\", \"Python\", 74), (\"Meera\", \"Data Science\", 91), (\"Sam\", \"Python\", 65)]\r\ncursor.executemany(sql, rows)\r\nmydb.commit()\r\nprint(cursor.rowcount, \"rows inserted\")\r\n\r\n# 8. Read the rows back\r\ncursor.execute(\"SELECT * FROM students\")\r\nfor row in cursor.fetchall():\r\n    print(row)\r\n\r\ncursor.execute(\"SELECT name, marks FROM students WHERE course = %s ORDER BY marks DESC\", (\"Python\",))\r\nprint(cursor.fetchall())\r\ncursor.execute(\"SELECT name FROM students WHERE id = %s\", (3,))\r\nprint(cursor.fetchone())\r\n\r\n# 9. Update and delete\r\ncursor.execute(\"UPDATE students SET marks = %s WHERE name = %s\", (88, \"Ravi\"))\r\nmydb.commit()\r\nprint(cursor.rowcount, \"row updated\")\r\n\r\ncursor.execute(\"DELETE FROM students WHERE name = %s\", (\"Sam\",))\r\nmydb.commit()\r\nprint(cursor.rowcount, \"row deleted\")\r\n\r\ncursor.execute(\"SELECT COUNT(*), AVG(marks) FROM students\")\r\nprint(cursor.fetchone())\r\n\r\n# 10. Roll back a mistake\r\ncursor.execute(\"DELETE FROM students\")\r\nprint(cursor.rowcount, \"rows deleted, not saved yet\")\r\nmydb.rollback()\r\ncursor.execute(\"SELECT COUNT(*) FROM students\")\r\nprint(cursor.fetchone()[0], \"rows still there after rollback\")\r\n\r\n# 11. Why placeholders matter\r\nbad_name = \"x' OR '1'='1\"\r\ncursor.execute(\"SELECT * FROM students WHERE name = %s\", (bad_name,))\r\nprint(\"Rows found with the tricky text:\", len(cursor.fetchall()))\r\n\r\n# 12. Handling errors\r\ntry:\r\n    cursor.execute(\"SELECT * FROM missing_table\")\r\nexcept Error as e:\r\n    print(\"Error:\", e.errno, e.msg)\r\n\r\ntry:\r\n    bad = mysql.connector.connect(host=HOST, user=USER, password=\"wrong_password\")\r\nexcept Error as e:\r\n    print(\"Connection failed:\", e.errno)\r\n\r\n# 13. Close everything when you are done\r\ncursor.close()\r\nmydb.close()\r\nprint(\"Connected:\", mydb.is_connected())<\/pre>\n<\/div>\n
      Connecting Python to MySQL is a short list of habits: connect with a safe user, send SQL through a cursor, use placeholders for every value, commit your changes, handle errors, and close the connection. Run the script above on a practice database, change the data, and break things on purpose. Then try a bigger project, such as a small student record app, or load the results of a query into pandas for analysis.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Python MySQL Connection Tutorial: Connect Python to MySQL With mysql.connector Almost every real application keeps its data in a database. A shop stores orders, a school stores marks, a company stores customers. Python can read and write that data, but it cannot talk to a database on its own. It needs a driver, a small […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,1670],"tags":[],"class_list":["post-6151","post","type-post","status-publish","format-standard","hentry","category-python","category-python-introduction"],"acf":[],"yoast_head":"\nPython MySQL Connection Tutorial with mysql.connector |Prwatech<\/title>\n<meta name=\"description\" content=\"Connect Python to MySQL step by step: install the connector, create a database and table, insert, select, update, delete, commit and fix errors.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python MySQL Connection Tutorial with mysql.connector |Prwatech\" \/>\n<meta property=\"og:description\" content=\"Connect Python to MySQL step by step: install the connector, create a database and table, insert, select, update, delete, commit and fix errors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/\" \/>\n<meta property=\"og:site_name\" content=\"Prwatech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prwatech.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-20T07:11:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-21T10:30:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/02\/image.png\" \/>\n<meta name=\"author\" content=\"Prwatech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:site\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prwatech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/\",\"url\":\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/\",\"name\":\"Python MySQL Connection Tutorial with mysql.connector |Prwatech\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/02\/image.png\",\"datePublished\":\"2026-10-20T07:11:09+00:00\",\"dateModified\":\"2026-10-21T10:30:30+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Connect Python to MySQL step by step: install the connector, create a database and table, insert, select, update, delete, commit and fix errors.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/02\/image.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/02\/image.png\",\"width\":628,\"height\":178},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python MySQL Connection\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prwatech.in\/blog\/#website\",\"url\":\"https:\/\/prwatech.in\/blog\/\",\"name\":\"Prwatech\",\"description\":\"Share Ideas, Start Something Good.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prwatech.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\",\"name\":\"Prwatech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"caption\":\"Prwatech\"},\"url\":\"https:\/\/prwatech.in\/blog\/author\/prwatech123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python MySQL Connection Tutorial with mysql.connector |Prwatech","description":"Connect Python to MySQL step by step: install the connector, create a database and table, insert, select, update, delete, commit and fix errors.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/","og_locale":"en_US","og_type":"article","og_title":"Python MySQL Connection Tutorial with mysql.connector |Prwatech","og_description":"Connect Python to MySQL step by step: install the connector, create a database and table, insert, select, update, delete, commit and fix errors.","og_url":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2026-10-20T07:11:09+00:00","article_modified_time":"2026-10-21T10:30:30+00:00","og_image":[{"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/02\/image.png","type":"","width":"","height":""}],"author":"Prwatech","twitter_card":"summary_large_image","twitter_creator":"@Eduprwatech","twitter_site":"@Eduprwatech","twitter_misc":{"Written by":"Prwatech","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/","url":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/","name":"Python MySQL Connection Tutorial with mysql.connector |Prwatech","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/02\/image.png","datePublished":"2026-10-20T07:11:09+00:00","dateModified":"2026-10-21T10:30:30+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Connect Python to MySQL step by step: install the connector, create a database and table, insert, select, update, delete, commit and fix errors.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/02\/image.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/02\/image.png","width":628,"height":178},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/python\/python-introduction\/python-mysql-connection\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Python MySQL Connection"}]},{"@type":"WebSite","@id":"https:\/\/prwatech.in\/blog\/#website","url":"https:\/\/prwatech.in\/blog\/","name":"Prwatech","description":"Share Ideas, Start Something Good.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prwatech.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3","name":"Prwatech","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","caption":"Prwatech"},"url":"https:\/\/prwatech.in\/blog\/author\/prwatech123\/"}]}},"_links":{"self":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/6151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/comments?post=6151"}],"version-history":[{"count":7,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/6151\/revisions"}],"predecessor-version":[{"id":12059,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/6151\/revisions\/12059"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=6151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=6151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=6151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}