我是python新手,刚开始是实现小程序,现在尝试连接数据库,我安装了python 3.4和mysql.connector 2.0.4。

下面是我用来连接数据库的代码#!"C:\python34\python.exe"

import sys

import mysql.connector

print("Content-Type: text/html;charset=utf-8")

print()

conn = mysql.connector.connect(host='localhost:8051',

database='test',

user='root',

password='tiger')

if conn.is_connected():

print('Connected to MySQL database')

但我得到的错误如下所示。由于安装环境错误或其他原因,无法获取发生此错误的原因

请建议Traceback (most recent call last):

File "C:\Python34\lib\site-packages\mysql\connector\network.py", line 448, in open_connection

socket.SOL_TCP)

File "C:\Python34\lib\socket.py", line 533, in getaddrinfo

for res in _socket.getaddrinfo(host, port, family, type, proto, flags):

socket.gaierror: [Errno 11004] getaddrinfo failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "", line 2, in

password='tiger',database='test')

File "C:\Python34\lib\site-packages\mysql\connector\__init__.py", line 179, in connect

return MySQLConnection(*args, **kwargs)

File "C:\Python34\lib\site-packages\mysql\connector\connection.py", line 95, in __init__

self.connect(**kwargs)

File "C:\Python34\lib\site-packages\mysql\connector\abstracts.py", line 719, in connect

self._open_connection()

File "C:\Python34\lib\site-packages\mysql\connector\connection.py", line 209, in _open_connection

self._socket.open_connection()

File "C:\Python34\lib\site-packages\mysql\connector\network.py", line 464, in open_connection

errno=2003, values=(self.get_address(), _strioerror(err)))

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:8051:3306' (11004 getaddrinfo failed)

Logo

一站式 AI 云服务平台

更多推荐