I'm trying to make Mysql and phpMyAdmin works.
I installed mysql using
Following those answers https://stackoverflow.com/questions/6474775/setting-the-mysql-root-user-password-on-os-x
I tried to set a plain text password
UPDATE mysql.user SET authentication_string='root' WHERE User='root';
But now when I try to login into phpmyadmin I get 2 errors (I'm not able to connect even with
mysql cli with "Access denied" error):
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client