MySQL Forums
Forum List  »  Security

ALTER USER mysql_native_password
Posted by: Anthony Yates
Date: June 02, 2019 12:02PM

I am working with a container that pulls the latest bitnami/mysql image. The container has a database user. A Wordpress container connects to this MySQL container. But the Wordpress container does not use SHA2 authentication, and so gets an error on connection.
I know there are different possible solutions to this problem, but I am trying to change the database user account to use mysql_native_password authentication.
I connect to the MySQL container as Root and use the syntax: ALTER USER 'bn_wordpress'@'localhost' IDENTIFIED WITH mysql_native_password. But it gives an error: ERROR 1396 (HY000): Operation ALTER USER failed.
What am I doing wrong?

Options: ReplyQuote

Written By
ALTER USER mysql_native_password
June 02, 2019 12:02PM

Sorry, you can't reply to this topic. It has been closed.

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.