MySQL ile denemeler yapıyordum ve oluşturduğum tablodan basirt bir şekilde veri çekmek istedim, yazdığım kod:
Aldığım hata ise bu, problem nedir?
File "c:\Users\Emre\Desktop\Python3\Python.py", line 3, in <module>
mydb = mysql.connector.connect(
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\__init__.py", line 179, in connect
return MySQLConnection(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\connection.py", line 95, in __init__
self.connect(**kwargs)
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\abstracts.py", line 716, in connect
self._open_connection()
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\connection.py", line 208, in _open_connection
self._do_auth(self._user, self._password,
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\connection.py", line 144, in _do_auth
self._auth_switch_request(username, password)
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\connection.py", line 167, in _auth_switch_request
auth = get_auth_plugin(new_auth_plugin)(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\authentication.py", line 190, in get_auth_plugin
raise errors.NotSupportedError(
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
import mysql.connector
mydb = mysql.connector.connect(
host = "localhost",
user = "root",
password = "abc123",
auth_plugin="mysql_native_password"
)
print(mydb)
Aldığım hata ise bu, problem nedir?
File "c:\Users\Emre\Desktop\Python3\Python.py", line 3, in <module>
mydb = mysql.connector.connect(
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\__init__.py", line 179, in connect
return MySQLConnection(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\connection.py", line 95, in __init__
self.connect(**kwargs)
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\abstracts.py", line 716, in connect
self._open_connection()
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\connection.py", line 208, in _open_connection
self._do_auth(self._user, self._password,
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\connection.py", line 144, in _do_auth
self._auth_switch_request(username, password)
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\connection.py", line 167, in _auth_switch_request
auth = get_auth_plugin(new_auth_plugin)(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Emre\AppData\Local\Programs\Python\Python311\Lib\site-packages\mysql\connector\authentication.py", line 190, in get_auth_plugin
raise errors.NotSupportedError(
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
[ICODE]
[/ICODE]
Son düzenleyen: Moderatör: