MYSQL 8.0 Connection With PHP 5.6

Question

I Have installed mysql 8.0 and try to connect it with php 5.6 and getting following error.

Warning: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

Warning: mysqli_connect(): (HY000/2054): The server requested authentication method unknown to the clien

Error: Unable to connect to MySQL. Debugging errno: 2054 Debugging error: The server requested authentication method unknown to the client

mithridates0 · Answer 1 · 2018-09-03T08:19:45.437

0

the mysqli library It may not be support on some servers; Use PDOinstead. Use these codes for connecting to Database with PDO:

    <?php
    $Host = "localhost";
    $dataBase = ""; //Write here the Name of Database
    $userName = ""; //Write here your username
    $Password = ""; //Write here your password
    $setName = array(PDO::MYSQL_ATTR_INIT_COMMAND =>'SET NAMES utf8');

    try{
        $connect = new PDO("mysql:host = $Host;dbname = $dataBase",$userName,$Password,$setName);
        echo 'Success...';
    }catch(PDOException $error) {
        echo 'Error !'. $error->getmessage();
    }
    ?>

edited Sep 03 '18 at 08:19

answered Sep 03 '18 at 05:42

mithridates0

3
2

3

A good answer includes an explanation of what problem the code solves and why. – M. Eriksson Sep 03 '18 at 05:45
Yes, Sorry, I am editing my answer, Thank you for your reminder – mithridates0 Sep 03 '18 at 06:10
Are you suggesting that it's the mysqli library that's missing? That's not what the error is about. The issue is that mysqli simply doesn't support the new default authentication method in MySQL 8. – M. Eriksson Sep 03 '18 at 06:12
thanks mithridates0 – Anuj Mishra Sep 03 '18 at 08:05
you're welcome Anuj – mithridates0 Sep 03 '18 at 08:18
3

Step 1) add the following line into etc/mysql/my.cnf [mysqld] default-authentication-plugin=mysql_native_password Step 2) ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; Step 3) Use PDO instead mysqli – Anuj Mishra Sep 03 '18 at 09:07
Thanks, @AnujMishra. It worked for me like a charm. – Amitesh Feb 13 '22 at 07:29

MYSQL 8.0 Connection With PHP 5.6

1 Answers1