default_authentication_plugin=mysql_native_password

[Giovanni Bianchini]

Thank you for your reply and sorry for being a burden.

I am on an incline for three reasons, one I am a newbie to MySql and PHP and two, I have chosen the latest releases of the software and three I chose a no-install install which may or not be a problem.

I applied the following changes to the php.ini file and copied it to the apache bin folder.

extension_dir ="C:\\php72\\ext" and under the extensions section extension=mysqli without the .dll as instructed.


Contents of mysqli in phpinfor() now are as follows

Client API library version mysqlnd 5.0.12-dev - 20150407 - $Id: 401a40ebd5e281cf22215acdc170723a1519aaa9 $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0

Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host localhost localhost
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user root root
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off
mysqli.rollback_on_cached_plink Off Off

The new message concerns the 8.0 caching_sha2_password authentication versus mysql_native_password.

The 8.0 Ref Manual section 2.11.1.3 states the easy temporary fix until a new mysqlnd is release is to add the last line to my.ini file which I did.

However, I now get the "Warning: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in C:\Apache24\htdocs\c.html on line 11"

[mysqld]
# set basedir to install path
basedir=C:/MYSQL
# set datadir to location of the data path
datadir=C:/MYSQL/DATA
# set default authentication type to depreciated standard
default_authentication_plugin=mysql_native_password

I am hoping there is an easy fix that has obviously slipped by me.

Thank you!