how to connect to MySQL databases using php in zend server

Question

I am trying to connect to my MySQL version 8.0.11 database in zend server version 7.2.10 using php but I could not connect it

Warning: mysqli::__construct(): Unexpected server respose while doing caching_sha2 auth: 109 in C:\Program Files (x86)\Zend\Apache24\htdocs\connectdatabase.php on line 7 Warning: mysqli::__construct(): MySQL server has gone away in C:\Program Files (x86)\Zend\Apache24\htdocs\connectdatabase.php on line 7 Warning: mysqli::__construct(): (HY000/2006): MySQL server has gone away in C:\Program Files (x86)\Zend\Apache24\htdocs\connectdatabase.php on line 7 Connection failed :MySQL server has gone away

I am getting the following warnings when i try to run my code.

i have searched and tried ALTER USER 'username'@'hostname' IDENTIFIED WITH mysql_native_password BY "userpassword" command but it does not work for me

<?php $servername = "localhost"; $username = "root"; $password = "hello"; $conn = new mysqli($servername,$username,$password); if(mysqli_connect_error()) { die("Connection failed :" . mysqli_connect_error()); } echo "CONNECTED SUCCESSFULLY"; ?>

Possible duplicate of PDOException::("PDO::__construct(): Unexpected server respose while doing caching_sha2 auth: 109") with MySQL 8 / PHP 7.2 / Laravel — digijay
– digijay, Commented Dec 23, 2018 at 11:33

EvE · Accepted Answer · 2018-12-23 09:29:28Z

Try with caching_sha2_password:

ALTER USER 'username'@'hostname'IDENTIFIED WITH caching_sha2_password BY 'userpassword';

Collectives™ on Stack Overflow

how to connect to MySQL databases using php in zend server

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related