CBSE CS and IP

CBSE Class 11 & 12 Computer Science and Informatics Practices Python Materials, Video Lecture

[SOLVED] mysql.connector.errors.NotSupportedError while executing Python Program

Are you facing error "mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported" or "authentication plugin 'caching_sha2_password' is not supported workbench" while executing the Python program and trying to connect the Python program with MySQL.


Follow the below steps to remove the error:

Step 1: Go To Start and Search MySQL
Authentication plugin 'caching_sha2_password' is not supported

Step 2: Inside MySQL click on MySQL Installer Community.

Step 3: Now click on Reconfigure on MySQL Server 
Authentication plugin 'caching_sha2_password' is not supported
Step 4: In the High Availability Menu click on "standalone MySQL Server / Classic MySQL Replication" and click Next
Authentication plugin 'caching_sha2_password' is not supported
 Step 5: Click Next on Type and Networking Menu
Authentication plugin 'caching_sha2_password' is not supported
Step 6: Now on Authentication Method choose Use Legacy Authentication Method (Retain MySQL 5.x Compatibility) and click Next
Authentication plugin 'caching_sha2_password' is not supported

Step 7: On Account and Roles give the Root Password of your MySQL and click check
Authentication plugin 'caching_sha2_password' is not supported

Step 8: ITS DONE. NOW CHECK YOUR PYTHON CODE. IT WILL NOT HAVE ANY ERROR.

No comments:

Post a Comment