MySQL Server

[cris 0]

Description: MySQL Database Server <img src="https://phptoday.ru/img-cache/storage/mysql/mysql8.png?p=home-carousel" alt="MySQL8" class="img-responsive"> MySQL open source software is provided under the GPL License. MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts. ---[ Integration Note ]--- DB initialised in system volume on a non shared directory call QMySQL Listen by default on port 23306 Socket by default /tmp/mysql8.sock Basic my.cnf in /opt/MySQL8/my.cnf error log inside QMySQL directory
Créateur: QoolBox

[Oneshot 0]

I have tried in vain to get this working.

It installs and runs OK - I just cannot access the database. Everytime I try it says that root@localhost is not allowed access. Using phpmyadmin results in "mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]"

So I am at a loss as to how to move on from here.

[Teigneux 0]

Le 06/11/2018 à 17:40, Oneshot a dit :

I have tried in vain to get this working.

It installs and runs OK - I just cannot access the database. Everytime I try it says that root@localhost is not allowed access. Using phpmyadmin results in "mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]"

So I am at a loss as to how to move on from here.

I have exactly the same problem!

[cbadoud 0]

The same problem for me. As I've understood till now, it should be an authentification  method problem .  I've added a line in my.cnf ( default_authentication_plugin=mysql_native_password ), but it still doesn't work.

[sgfgator 0]

On 1/25/2019 at 8:08 AM, Teigneux said:

I have exactly the same problem!

Same here. Cant login.