mysql数据库本机连不上

sudo systemctl status mysql

sudo systemctl start mysql

sudo netstat -tuln | grep 3306

[mysqld]
bind-address = 127.0.0.1  # 或者注释掉此行以允许所有 IP 连接
port = 3306

mysql -u root -p

SELECT User, Host FROM mysql.user;

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

sudo ufw allow 3306

sudo iptables -A INPUT -p tcp --dport 3306 -j ACCEPT

import mysql.connector

try:
    conn = 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 conn.is_connected():
        conn.close()