mysql 连接错误

sudo systemctl status mysql

sudo systemctl start mysql

import mysql.connector

try:
    connection = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )
    print("Connection successful")
except mysql.connector.Error as err:
    print(f"Error: {err}")

sudo ufw status
sudo ufw allow 3306

mysql -u root -p
SHOW GRANTS FOR 'yourusername'@'localhost';

GRANT ALL PRIVILEGES ON yourdatabase.* TO 'yourusername'@'localhost';
FLUSH PRIVILEGES;

import mysql.connector

try:
    connection = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )
    
    cursor = connection.cursor()
    cursor.execute("SELECT * FROM yourtable")
    results = cursor.fetchall()
    
    for row in results:
        print(row)
    
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()