Initially, default mysql settings, comes with “auth_socket” plugin for root user.
In my case I was unable to login to phpmyadmin from web browser using root user
Login to mysql
To see which plugin used for specific user we need to login to our mysql from command line
|
|
Plugin used for user
in mysql
Once we login to mysql, we can view current used plugin for user, using following code
|
|
Alter user for replacing auth_socket
plugin by mysql_native_password
we can change user plugin using following code
|
|
here I kept password empty string
thanks