我正在嘗試使用 python 連接到我的本地 mysql 系統。我注意到我只能通過 sudo /usr/bin/mysql -u root -p 從控制臺登錄到我的 mysql 系統我環顧了網絡，對所有對我都不起作用的建議感到非常困惑。就像我試過的mysql> SELECT User, Host, plugin FROM mysql.user;這給了我...+------------------+-----------+-----------------------+| User | Host | plugin |+------------------+-----------+-----------------------+| root | localhost | mysql_native_password || mysql.session | localhost | mysql_native_password || mysql.sys | localhost | mysql_native_password || debian-sys-maint | localhost | mysql_native_password || keith | localhost | mysql_native_password |+------------------+-----------+-----------------------+5 rows in set (0.12 sec)......import mysql.connectorcnx = mysql.connector.connect(user='root', password='#########', host='127.0.0.1', database='SurveyData')cnx.close()...我收到以下錯誤...MySQLInterfaceError Traceback (most recent call last)~/miniconda3/lib/python3.7/site-packages/mysql/connector /connection_cext.py in _open_connection(self) 199 try:--> 200 self._cmysql.connect(**cnx_kwargs) 201 except MySQLInterfaceError as exc:MySQLInterfaceError: Access denied for user 'root'@'localhost'During handling of the above exception, another exception occurred:
2 回答
一只萌萌小番薯
TA貢獻1795條經驗 獲得超7個贊
使用 root 用戶登錄可以被視為“潛在風險”，這解釋了通過該用戶進行的任何連接的阻塞。因此解決方案是創建一個新用戶并授予他們所有權限。
mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'newpassword';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';
守著星空守著你
TA貢獻1799條經驗 獲得超8個贊
通過命令行向用戶帳戶授予全局權限。打開終端并運行以下命令。
:~$ mysql -u root -p
Enter password:
mysql> GRANT SELECT ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
向用戶帳戶授予特殊架構特權。打開終端運行下面的命令。
:~$ mysql -u root -p
Enter password:
mysql> GRANT SELECT,UPDATE,INSERT,DELETE ON SurveyData.* TO 'root'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON SurveyData.* TO 'root'@'localhost';
Query OK, 0 rows affected (0.00 sec)
我使用這個腳本進行測試：
try:
connection = mysql.connector.connect(host='localhost',
database='SurveyData',
user='root',
password='########')
if connection.is_connected():
db_Info = connection.get_server_info()
print("Connected to MySQL Server version ", db_Info)
cursor = connection.cursor()
cursor.execute("select database();")
record = cursor.fetchone()
print("Your connected to database: ", record)
except Error as e:
print("Error while connecting to MySQL", e)
finally:
if (connection.is_connected()):
cursor.close()
connection.close()
print("MySQL connection is closed")
添加回答
舉報
0/150
提交
取消