python建立数据库连接时出错_使用mysql.connector for python连接数据库时出错
我是python新手,刚开始是实现小程序,现在尝试连接数据库,我安装了python 3.4和mysql.connector 2.0.4。下面是我用来连接数据库的代码#!"C:\python34\python.exe"import sysimport mysql.connectorprint("Content-Type: text/html;charset=utf-8")print()conn =
我是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)
更多推荐




所有评论(0)