cris 0 Report post Posted November 2, 2018 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 Share this post Link to post Share on other sites
Oneshot 0 Report post Posted November 6, 2018 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. Share this post Link to post Share on other sites
Teigneux 0 Report post Posted January 25, 2019 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! Share this post Link to post Share on other sites
cbadoud 0 Report post Posted September 6, 2019 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. Share this post Link to post Share on other sites
sgfgator 0 Report post Posted February 17 On 1/25/2019 at 8:08 AM, Teigneux said: I have exactly the same problem! Same here. Cant login. Share this post Link to post Share on other sites