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 220.127.116.11 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"
# set basedir to install path
# set datadir to location of the data path
# set default authentication type to depreciated standard
I am hoping there is an easy fix that has obviously slipped by me.
November 16, 2018 04:21PM
November 16, 2018 05:52PM
November 16, 2018 06:04PM
November 16, 2018 07:44PM
November 17, 2018 09:46AM
November 17, 2018 09:49PM
November 17, 2018 11:17AM
November 19, 2018 07:52AM
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.