0

I am writing a program for a school project using python and MySQL. When I try to connect python with MySQL this error pops up Authentication plugin 'auth_gssapi_client' cannot be loaded Does someone know how to fix it? Im on windows 10.

I tried several things recommended by other posts but they all didnt work.

Here's one of them: MySQL Workbench dialog.dll for PAM connection

Thanks in advance

Heres my code:

import mysql.connector
from mysql.connector import Error

try:
connection = mysql.connector.connect(host='localhost',
                                     database='quiz',
                                     user='root',
                                     password='1234')
except Error as e:
print("Error while connecting to MySQL", e)
finally:
if connection.is_connected():
    connection.close()
    print("MySQL connection is closed")
Lenntox
  • 15
  • 5
  • The first question is: do you want to use kerberos authentication in the first place? If not, then change the user's authentication type in mysql to use simple password hashing. If you do want to use kerberos authentication, then you should configure that properly and not use username and password pair. – Shadow Jun 21 '23 at 08:01
  • @Shadow Thanks for your response, Where can I disable/remove the kerberos auth? I dont think I will need it – Lenntox Jun 21 '23 at 11:21
  • https://stackoverflow.com/a/60693487/5389997 – Shadow Jun 21 '23 at 12:01
  • @Shadow I still get the exact same error – Lenntox Jun 22 '23 at 06:21

0 Answers0