Navicat连接数据库时用户名和密码错误的排查步骤

import mysql.connector

# 连接数据库
try:
    connection = mysql.connector.connect(
        host='localhost',
        user='your_username',
        password='your_password',
        database='your_database'
    )

    if connection.is_connected():
        print("连接成功")
except mysql.connector.Error as error:
    print(f"连接失败: {error}")

import mysql.connector

# 尝试连接数据库
try:
    connection = mysql.connector.connect(
        host='127.0.0.1',
        port=3306,
        user='root',
        password='password123',
        database='testdb'
    )

    if connection.is_connected():
        print("连接成功")
except mysql.connector.Error as error:
    print(f"连接失败: {error}")

import mysql.connector
from mysql.connector import SSL

# 配置SSL连接
ssl_config = {
    'ssl': {
        'ca': '/path/to/ca-cert.pem',
        'cert': '/path/to/client-cert.pem',
        'key': '/path/to/client-key.pem'
    }
}

try:
    connection = mysql.connector.connect(
        host='127.0.0.1',
        port=3306,
        user='root',
        password='password123',
        database='testdb',
        **ssl_config
    )

    if connection.is_connected():
        print("SSL连接成功")
except mysql.connector.Error as error:
    print(f"SSL连接失败: {error}")

import mysql.connector
from mysql.connector import pooling

# 创建连接池
dbconfig = {
    "database": "testdb",
    "user": "root",
    "password": "password123",
    "host": "127.0.0.1",
    "port": 3306
}

try:
    connection_pool = mysql.connector.pooling.MySQLConnectionPool(
        pool_name="mypool",
        pool_size=5,
        **dbconfig
    )

    # 从连接池中获取连接
    connection = connection_pool.get_connection()
    if connection.is_connected():
        print("从连接池中获取连接成功")
except mysql.connector.Error as error:
    print(f"从连接池中获取连接失败: {error}")