pythonでmysql.connectorを使いデータベースに接続したいのでが不可能です。
python
1import mysql.connector 2 3conn = mysql.connector.connect( 4 host = 'localhost', 5 port = 3306, 6 user = 'root', 7 password = 'pass', 8 database = 'test', 9)
実行すると...
Traceback (most recent call last): File "test.py", line 8, in <module> database = 'test', File "/home/pi/.local/lib/python3.5/site-packages/mysql/connector/__init__.py", line 173, in connect return MySQLConnection(*args, **kwargs) File "/home/pi/.local/lib/python3.5/site-packages/mysql/connector/connection.py", line 102, in __init__ self.connect(**kwargs) File "/home/pi/.local/lib/python3.5/site-packages/mysql/connector/abstracts.py", line 735, in connect self._open_connection() File "/home/pi/.local/lib/python3.5/site-packages/mysql/connector/connection.py", line 252, in _open_connection self._ssl) File "/home/pi/.local/lib/python3.5/site-packages/mysql/connector/connection.py", line 172, in _do_auth self._auth_switch_request(username, password) File "/home/pi/.local/lib/python3.5/site-packages/mysql/connector/connection.py", line 216, in _auth_switch_request raise errors.get_exception(packet) mysql.connector.errors.ProgrammingError: 1698 (28000): Access denied for user 'root'@'localhost'
ほかのモジュール等でも同じ結果ですのでデータベースに原因がありそうです。
環境
Raspbian
Pyhotn3
Mariadb
宜しくお願いします。
回答1件
あなたの回答
tips
プレビュー