Seems like I am using an older version on Mysql Server which uses sha_256 plugin for Authentication (which is now deprecated) .Because of this, I am unable to connect to my server with third party softwares like beekeper studio.

But I am able to connect from the terminal itself. So I went through the Mysql manual . It shows how to change the default authentication plugin , but before changing it, I just want to know what is my default authentication plugin. How to do that?

1 Answer 1


When you have a connection, (ref SHOW CREATE USER),

show create user {user}

will how you the plugin used for any specific user.

SHOW GLOBAL VARIABLES LIKE 'default_authentication_plugin'

will show which authentication is used for created users if none is specified. ref

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.