mysql 链接异常

ping your_mysql_server

import mysql.connector

try:
    conn = mysql.connector.connect(
        host="your_host",
        user="your_user",
        password="your_password",
        database="your_database"
    )
except mysql.connector.Error as err:
    print(f"Error: {err}")

SHOW GRANTS FOR 'your_user'@'your_host';

sudo systemctl start mysql

[mysqld]
bind-address = 0.0.0.0
port = 3306

sudo ufw allow 3306/tcp

import mysql.connector

try:
    conn = mysql.connector.connect(
        host="localhost",
        user="root",
        password="password",
        database="testdb"
    )
    print("Connected to MySQL database!")
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Something is wrong with your user name or password")
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
        print("Database does not exist")
    else:
        print(err)
finally:
    if conn.is_connected():
        conn.close()
        print("MySQL connection is closed")