[Calisthenics]

PHP is not compatitible with caching_sha2_password method yet anyway. Connect to mysql server via command line and change your password:

pawn Code:

ALTER USER 'user'@'host' IDENTIFIED WITH mysql_native_password BY 'password';

Set in my.ini the authentication method and restart service again:

pawn Code:

[mysqld]
default_authentication_plugin = mysql_native_password

You can also pass configuration parameters when installing and initialize mysql like:

pawn Code:

> mysqld --install
> mysqld --initialize --default-authentication-plugin=mysql_native_password --secure-file-priv="..." 
> net start mysql