MySQL Forums
Forum List  »  PHP

Posted by: Giovanni Bianchini
Date: November 17, 2018 09:46AM

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 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.

Thank you!

Options: ReplyQuote

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.