Issue:
When we install MySQL 8 server on the PC. And try to open SQLyog for database import. at that, we are getting errors while login SQLyog. Our Password (aipl12*) will not be accepted by SQLyog.
Solution:
1. Open MySQL 8.0 Command line (See attached screenshot)
2. Then Execute the below command. (You can change the password as you required,
Insert a new password in the aipl12* place )
3. Then Try Again to Login SQLyog
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'aipl12*';