怎么测试mysql连接

mysql -h hostname -u username -p

import mysql.connector

def test_mysql_connection():
    try:
        connection = mysql.connector.connect(
            host="hostname",
            user="username",
            password="password",
            database="database_name"
        )
        if connection.is_connected():
            print("Successfully connected to MySQL database")
        connection.close()
    except mysql.connector.Error as err:
        print(f"Error: '{err}'")

test_mysql_connection()

pip install mysql-connector-python

import unittest
import mysql.connector

class TestMySQLConnection(unittest.TestCase):
    def test_connect(self):
        connection = mysql.connector.connect(
            host="hostname",
            user="username",
            password="password",
            database="database_name"
        )
        self.assertTrue(connection.is_connected())
        connection.close()

if __name__ == '__main__':
    unittest.main()