ALTER USER mysql_native_password
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?
Subject
Views
Written By
Posted
ALTER USER mysql_native_password
6873
June 02, 2019 12:02PM
1474
June 02, 2019 01:53PM
876
June 02, 2019 02:58PM
897
June 02, 2019 03:40PM
836
June 03, 2019 11:49AM
1002
June 04, 2019 05:59AM
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.