XAMPP - Errors with MySQL & phpMyAdmin

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP - Errors with MySQL & phpMyAdmin

Postby mc96 » 23. January 2019 12:22

Hello,

Just finished setting up XAMPP, changed some settings for the MySQL & XAMPP services (changed port 3306 to 3307 for the purposes of SQL) as 3306 was in use already by another app.

When trying to load lcoalhost/phpmyadmin i get these errors:
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
Connection for controluser as defined in your configuration failed.
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
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Haven't really amended much so I don't see how it isn't working? Any help would be massively appreciated.
mc96
 
Posts: 1
Joined: 23. January 2019 12:18
XAMPP version: 3.2.2
Operating System: Windows 10 & Ubuntu 18.04

Re: XAMPP - Errors with MySQL & phpMyAdmin

Postby Altrea » 23. January 2019 14:12

Did you tell phpmyadmin too how the new connection port to MariaDB is now?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11941
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 87 guests