总的来说,我是编程的初学者。我试图创建一个sql数据库。不幸的是,我的代码的这一部分总是返回一个错误:
import mysql.connector
MainDatabase = mysql.connector.connect(
host ="127.0.0.1",
user ="Username",
password ="Idon'tknowE"错误是:
Traceback (most recent call last):
File "/Users/My Name/xx/Program/Scripts/test.py", line xx, in <module>
database="mydatabase"
File "/Users/My Name/Library/Python/3.7/lib/python/site-packages/mysql/connector/__init__.py", line 179, in connect
return MySQLConnection(*args, **kwargs)
File "/Users/My Name/Library/Python/3.7/lib/python/site-packages/mysql/connector/connection.py", line 95, in __init__
self.connect(**kwargs)
File "/Users/My Name/Library/Python/3.7/lib/python/site-packages/mysql/connector/abstracts.py", line 716, in connect
self._open_connection()
File "/Users/My Name/Library/Python/3.7/lib/python/site-packages/mysql/connector/connection.py", line 206, in _open_connection
self._socket.open_connection()
File "/Users/My Name/Library/Python/3.7/lib/python/site-packages/mysql/connector/network.py", line 512, in open_connection
errno=2003, values=(self.get_address(), _strioerror(err)))
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (61 Connection refused)我是在mac上运行的,更具体地说,是Catalina。有人知道这是怎么回事或者怎么解决这个问题吗?
发布于 2022-06-28 10:47:41
MySQL是一个独立于python的应用程序,它应该与您的应用程序同时运行。然后你写的代码把你和它连接起来。
由于MySQL不在您的计算机上运行,所以您的代码无法工作。或者MySQL正在运行,但不是在您指定的入口。
您可以从这里开始安装它:
https://dev.mysql.com/doc/refman/5.7/en/installing.html
然后,您需要设置一个具有代码中使用的凭据的用户,然后您需要确保您使用的是mysql运行的正确入口。
https://stackoverflow.com/questions/72784907
复制相似问题