MySQL Forums
Forum List  »  Install & Repo

Re: Change server from caching_sha2_password to password
Posted by: Terje Røsten
Date: May 22, 2023 02:00AM

The default-authentication-plugin option sets the default auth plugin during *creation* of user account and what server offers as first auth method.

Accounts that are present already is not changed, the auth plugin is property of *each* account.

To use mysql_native_password plugin for a account, use

CREATE USER '<user>'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';

For more details, see:

https://dev.mysql.com/doc/refman/8.0/en/create-user.html#create-user-authentication
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html#pluggable-authentication-default-plugin

Options: ReplyQuote


Subject
Written By
Posted
Re: Change server from caching_sha2_password to password
May 22, 2023 02:00AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.