mysql总是拒绝访问

-- 检查用户权限
SHOW GRANTS FOR 'username'@'host';

-- 授予权限
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'host';

-- 刷新权限
FLUSH PRIVILEGES;

import mysql.connector

config = {
    'user': 'username',
    'password': 'password',
    'host': '127.0.0.1',
    'database': 'database_name',
    'raise_on_warnings': True
}

try:
    cnx = mysql.connector.connect(**config)
    cursor = cnx.cursor()
    cursor.execute("SELECT * FROM table_name")
    for row in cursor:
        print(row)
except mysql.connector.Error as err:
    print(f"Something went wrong: {err}")
finally:
    cursor.close()
    cnx.close()

sudo netstat -tuln | grep 3306

sudo systemctl status mysql

sudo systemctl start mysql