mysql数据库的账户密码

-- 跳过权限表启动 MySQL
mysqld_safe --skip-grant-tables &

-- 登录并更新密码
mysql -u root
UPDATE mysql.user SET authentication_string=PASSWORD('new_password') WHERE User='root';
FLUSH PRIVILEGES;

[mysqld]
validate_password_policy=MEDIUM
validate_password_length=8

import mysql.connector

config = {
  'user': 'your_username',
  'password': 'your_password',
  'host': '127.0.0.1',
  'database': 'your_database',
  'raise_on_warnings': True
}

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