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
6917
June 02, 2019 12:02PM
1485
June 02, 2019 01:53PM
884
June 02, 2019 02:58PM
905
June 02, 2019 03:40PM
844
June 03, 2019 11:49AM
1016
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.