SQLyog MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found !

Windows 10
MYSQL VER.8
SQLYOG VER.8
---------------------------------------------------------------------------------------------------------------------------
Locate this in file explorer:

---------------------------------------------------------------------------------------------------------------------------
#default_authentication_plugin=caching_sha2_password (comment line!)
default_authentication_plugin=mysql_native_password (new line)

---------------------------------------------------------------------------------------------------------------------------
Query in workbench :
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';

---------------------------------------------------------------------------------------------------------------------------
Search services at Start Window

-------------------------------------------------------------------------------------------------------------------------
Background music :
Title : [Non-Copyrighted Music] Chill Jazzy Lofi Hip Hop (Royalty Free) Jazz Hop Music

-------------------------------------------------------------------------------------------------------------------------
SQLyog MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found !
SQLyog MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found !
MySQL Workbench Cannot Connect to Database Server -'caching_sha2_password' cannot be loaded

-------------------------------------------------------------------------------------------------------------------------
Subscribe !!Subscribe !!Subscribe !!Subscribe !!Subscribe !!Subscribe !!

#programming #code #java #mysql #win10 #window #sqlyog #mysqlserver #error #cahing #sha2 #password

[krishanradadia]

Thank you for this video really helped in sorting out the issue.

[tiksunyo]

Holy shit thank you, you must be the Jesus in programming for you have saved me from this hell hole of programming problem!

[sumitnegi]

it is 100% working the imp task in video is to hit query shown in video on workbench restart sqlyog type password again and good to go

[mangonmeth]

Another Alternative way, use this line of code : ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';