连不上本地mysql

sudo systemctl status mysql

sudo systemctl start mysql

[mysqld]
bind-address = 127.0.0.1
port = 3306

sudo ufw allow 3306

mysql -u root -p

SELECT User, Host FROM mysql.user;

GRANT ALL PRIVILEGES ON *.* TO 'your_username'@'localhost' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

ping your_mysql_server_ip

import mysql.connector

try:
    connection = mysql.connector.connect(
        host="localhost",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    print("Connected to MySQL database")
except mysql.connector.Error as err:
    print(f"Error: '{err}'")
finally:
    if connection.is_connected():
        connection.close()
        print("MySQL connection is closed")