mysql - 我正在尝试连接 python 和 mysql，但遇到以下错误：

Question

源代码：

import mysql.connector

from mysql.connector import errorcode
try:
    cnx = mysql.connector.connect(user='root',database='menagerie')
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Something is wrong with your user name or password")
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
        print("Database does not exist")
    else:
        print(err)
else:
    cnx.close()

我面临的错误： 2003: Can't connect to MySQL server on '127.0.0.1:3306' (10061 No connection could be made because the target machine positively denied it)

标签： mysqlpython-3.x

Answer 1

import mysql.connector
cnx=mysql.connector.connect(user="root",host="localhost",passwd="*******",database="menagerie")

上面的代码建立了与 MySql 的连接。