老师,我这么处理了数据库名字,但是还是报错。
import mysql.connector.pooling
class cs:
def css(self):
config={
"host": "cluster-cgtif4qwlwcf.ap-southeast-1.rds.amazonaws.com",
'port':'3306',
'user':'admin',
'password':'*******',
'database':'mark1'
}
#con = mysql.connector.connect(**config)
#cursor = con.cursor()
pool=mysql.connector.pooling.MySQLConnectionPool(**config,pool_size=10,pool_name='hc-dev')
con=pool.get_connection()
cursor=con.cursor()
sql = "SELECT captcha_code FROM captcha_send_record WHERE send_email='11111@qq.com' ORDER BY create_time LIMIT 1;"
cursor.execute(sql)
invite_code=cursor.fetchone()[0]
print(invite_code)
return invite_code
con.close()
if __name__=='__main__':
cs=cs()
cs.css()
D:\PyCharm\untitled\venv\Scripts\python.exe D:/PyCharm/untitled/imooc/mark/sqldb/markmysql.py
Traceback (most recent call last):
File "D:\python3\lib\site-packages\mysql\connector\network.py", line 547, in open_connection
addrinfos = socket.getaddrinfo(self.server_host,
File "D:\python3\lib\socket.py", line 918, in getaddrinfo
for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno 11001] getaddrinfo failed
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:/PyCharm/untitled/imooc/mark/sqldb/markmysql.py", line 44, in <module>
cs.css()
File "D:/PyCharm/untitled/imooc/mark/sqldb/markmysql.py", line 30, in css
pool=mysql.connector.pooling.MySQLConnectionPool(**config,pool_size=10,pool_name='hc-dev')
File "D:\python3\lib\site-packages\mysql\connector\pooling.py", line 179, in __init__
self.add_connection()
File "D:\python3\lib\site-packages\mysql\connector\pooling.py", line 290, in add_connection
cnx = Connect(**self._cnx_config)
File "D:\python3\lib\site-packages\mysql\connector\__init__.py", line 273, in connect
return MySQLConnection(*args, **kwargs)
File "D:\python3\lib\site-packages\mysql\connector\connection.py", line 107, in __init__
self.connect(**kwargs)
File "D:\python3\lib\site-packages\mysql\connector\abstracts.py", line 1003, in connect
self._open_connection()
File "D:\python3\lib\site-packages\mysql\connector\connection.py", line 350, in _open_connection
self._socket.open_connection()
File "D:\python3\lib\site-packages\mysql\connector\network.py", line 565, in open_connection
raise errors.InterfaceError(
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '%-.100s:%u' (%s) (Warning: %u format: a number is required, not str)
Process finished with exit code 1
正在回答
同学,你好!
config的参数中host填写mysql的服务器地址,本机地址为127.0.0.1,端口号一般为3306;云服务器填云服务器的IP地址,port为云服务中mysql的端口号,如下图:
祝学习愉快~
- 参与学习 人
- 提交作业 5231 份
- 解答问题 2433 个
Facebook曾声称“只招全栈工程师”!全栈用人需求猛增,市面人才紧缺。 0基础进击Python全栈开发,诱人薪资在前方!
了解课程
恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星