pycharm连接mysql数据库代码

To connect to a MySQL database using PyCharm, you can use the mysql-connector-python library, which is a MySQL driver for Python. First, you need to install the library if you haven't already:

bash
pip install mysql-connector-python

Once the library is installed, you can use the following code to connect to a MySQL database in PyCharm:

python
import mysql.connector

# Replace 'your_host', 'your_database', 'your_user', and 'your_password' with your actual MySQL connection details
db_config = {
    "host": "your_host",
    "user": "your_user",
    "password": "your_password",
    "database": "your_database"
}

# Establish a connection to the MySQL server
conn = mysql.connector.connect(**db_config)

# Create a cursor object to interact with the database
cursor = conn.cursor()

# Example: Execute a simple query
cursor.execute("SELECT * FROM your_table")
result = cursor.fetchall()

# Example: Print the results
for row in result:
    print(row)

# Close the cursor and connection
cursor.close()
conn.close()

Make sure to replace 'your_host', 'your_database', 'your_user', 'your_password', and 'your_table' with your actual MySQL connection details.

This is a basic example. Depending on your use case, you may need to handle exceptions, commit changes, or perform other database operations. Refer to the official documentation of mysql-connector-python for more details: https://pynative.com/python-mysql-database-connection/

Certainly! Here's an extended example that includes exception handling and demonstrates how to insert data into a MySQL database using the mysql-connector-python library:

python
import mysql.connector
from mysql.connector import Error

def connect_to_mysql():
    try:
        # Replace 'your_host', 'your_database', 'your_user', and 'your_password' with your actual MySQL connection details
        db_config = {
            "host": "your_host",
            "user": "your_user",
            "password": "your_password",
            "database": "your_database"
        }

        # Establish a connection to the MySQL server
        conn = mysql.connector.connect(**db_config)

        if conn.is_connected():
            print("Connected to MySQL database")

            # Create a cursor object to interact with the database
            cursor = conn.cursor()

            # Example: Execute a simple query
            cursor.execute("SELECT * FROM your_table")
            result = cursor.fetchall()

            # Example: Print the results
            print("Data from your_table:")
            for row in result:
                print(row)

            # Example: Insert data into your_table
            insert_query = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)"
            data_to_insert = ("value1", "value2")

            cursor.execute(insert_query, data_to_insert)
            conn.commit()  # Commit the changes

            print("Data inserted into your_table")

            # Close the cursor and connection
            cursor.close()
            conn.close()

    except Error as e:
        print("Error:", e)

if __name__ == "__main__":
    connect_to_mysql()

Make sure to replace 'your_host', 'your_database', 'your_user', 'your_password', and 'your_table' with your actual MySQL connection details and table information.

This example demonstrates connecting to the MySQL database, querying data from a table, and inserting new data into the table. Remember to handle exceptions appropriately in your production code.