老师,我这么处理了数据库名字,但是还是报错。

老师,我这么处理了数据库名字,但是还是报错。



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


正在回答

登陆购买课程后可参与讨论,去登陆

1回答

同学,你好!

​config的参数中host填写mysql的服务器地址,本机地址为127.0.0.1,端口号一般为3306;云服务器填云服务器的IP地址,port为云服务中mysql的端口号,如下图:

https://img1.sycdn.imooc.com//climg/613424e2095042e312580363.jpg

祝学习愉快~

  • 热爱编程学习 提问者 #1

    老师。就是遇到这样云端数据库,这种很长名称时候,应该怎么处理呢?

    2021-09-05 14:13:58
  • 好帮手慕凡 回复 提问者 热爱编程学习 #2

    同学,你好!

    host参数填写云服务的IP地址就可以,首先要知道自己所用服务器的ip地址;

    port参数填写云服务中mysql的端口号,在cmd中登录mysql,使用show global variables like 'port'查询端口号,如下图:端口号为 3306

    https://img1.sycdn.imooc.com//climg/61346bc809cffbef06600433.jpg

    祝学习愉快~

    2021-09-05 15:04:07
  • 热爱编程学习 提问者 回复 好帮手慕凡 #3

    老师怎么查这个IP在哪看呢?😵

    https://img1.sycdn.imooc.com//climg/61349b4709c96cc518960624.jpg

    2021-09-05 18:26:52
问题已解决,确定采纳
还有疑问,暂不采纳

恭喜解决一个难题,获得1积分~

来为老师/同学的回答评分吧

0 星
请稍等 ...
意见反馈 帮助中心 APP下载
官方微信

在线咨询

领取优惠

免费试听

领取大纲

扫描二维码,添加
你的专属老师