PHPMyAdmin doesn’t work with MYSQL 8.0.11

  • fennng 
I ran a mysql in docker
docker run –name mysql –network wp-net –network-alias mysql-host -e MYSQL_ROOT_PASSWORD=root mysql
Then ran a phpmyadmin in docker to connect to it
docker run –name myadmin –rm –link mysql:db \
            –network wp-net \
            –network-alias myadmin-host \
            -p 8083:80 phpmyadmin/phpmyadmin
I go this error:
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
 mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

The working version:

A quick solution is using older version of mysql
docker run –name mysql –network wp-net –network-alias mysql-host -e MYSQL_ROOT_PASSWORD=root mysql:5.7.22
Problem solved.
You can also config mysql 8.0.11 to use old password

《PHPMyAdmin doesn’t work with MYSQL 8.0.11》有2个想法

  1. How do you go about using older version of mysql in light of this comment on https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html:

    Note:
    Downgrade from MySQL 8.0 to MySQL 5.7 (or from a MySQL 8.0 release to a previous MySQL 8.0 release) is not supported. The only supported alternative is to restore a backup taken before upgrading.

    I already have Apache 2.4.33 Win64, php-7.2.5, mysql-8.0.11-winx64 and phpMyAdmin-4.8.0.1 installed and getting the following error:

    Cannot log in to the MySQL server

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

    mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

    How do I downgrade mysql-8.0.11 to a lower version?

    1. Hey, I am not sure what the comment mean here. It may mean that they cannot downgrade a mysql 8.0 db to mysql 5.7 db (migrating all the db data into a older version db). Because phpmyadmin doesn’t support mysql 8.0. So What I did is running a older version of mysql. I started a new empty db instance. Instead of mysql-8.0.11-winx64, you need to install mysql-5.

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注