学习过程中,练习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)
您好,我是有问必答小助手,您的问题已经有小伙伴帮您解答,感谢您对有问必答的支持与关注!