mac python链接mysql报错,(2003, "Can't connect to MySQL server on 'localhost' ([Errno 8]

问题遇到的现象和发生背景

学习过程中,练习python链接数据库,服务打开了,客户端用这个账号和密码也能链接,但是还是报错

问题相关代码,请勿粘贴截图

from pymysql import *

conn = connect(host="localhost", port=3306, database="jing_dong", user="root", password="renyuanyuan", charset="utf8")

cs1 = conn.cursor()

sql = "select * from goods;"
content = cs1.execute(sql)
print(content)

cs1.close()
conn.close()

运行结果及报错内容

pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 8] nodename nor servname provided, or not known)")

Process finished with exit code 1

我的解答思路和尝试过的方法
我想要达到的结果

这里帖子里有相应的解决办法,题主可以参考尝试一下:
https://blog.csdn.net/qq_44761250/article/details/113462119

conn = connect()这里应该是conn = pymysql.connect(xxx)

您好,我是有问必答小助手,您的问题已经有小伙伴帮您解答,感谢您对有问必答的支持与关注!
PS:问答VIP年卡 【限时加赠:IT技术图书免费领】,了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632