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

 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)<br>        #cursor = con.cursor()<br><br>        pool=mysql.connector.pooling.MySQLConnectionPool(**config,pool_size=10,pool_name='hc-dev')<br>        con=pool.get_connection()<br>        cursor=con.cursor()<br>        sql = "SELECT captcha_code FROM captcha_send_record WHERE send_email='11111@qq.com' ORDER BY create_time LIMIT 1;"<br><br>        cursor.execute(sql)<br>        invite_code=cursor.fetchone()[0]<br>        print(invite_code)<br>        return invite_code<br>        con.close()<br><br><br>if __name__=='__main__':<br>    cs=cs()<br>    cs.css()<br><br><br><br><br><br><br>

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

热爱编程学习 2021-09-04

源自：数据库表的相关操作 2-6 选择练习

收起

1回答

好帮手慕凡回答被采纳获得+3积分 2021-09-05 10:06:37

同学，你好！

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

祝学习愉快~

收起回答

热爱编程学习提问者 #1

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

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

同学，你好！
host参数填写云服务的IP地址就可以，首先要知道自己所用服务器的ip地址；
port参数填写云服务中mysql的端口号，在cmd中登录mysql，使用show global variables like 'port'查询端口号，如下图：端口号为 3306
祝学习愉快~

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

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

2021-09-05 18:26:52