-
2026 staff recruitment is open! Check it out and consider applying!
Help with this error
- Thread starter tatiana
- Start date
It looks like you are using MySQL 8.0 server. If you can, replace it with MariaDB (it's MySQL compatible) or change user authentication to
mysql_native_password:
Fixing "Authentication plugin 'caching_sha2_password' cannot be loaded" errors
As of MySQL 8.0, `caching_sha2_password` is now the default authentication plugin rather than `mysql_native_password` which was the default in previous versions. This means that clients (Sequel Pro, HeidiSQL etc) that rely on the `mysql_native_password` won't be able to connect because of this...
chrisshennan.com
I'm using UniServer Zero XVIt looks like you are using MySQL 8.0 server. If you can, replace it with MariaDB (it's MySQL compatible) or change user authentication tomysql_native_password:
Fixing "Authentication plugin 'caching_sha2_password' cannot be loaded" errors
As of MySQL 8.0, `caching_sha2_password` is now the default authentication plugin rather than `mysql_native_password` which was the default in previous versions. This means that clients (Sequel Pro, HeidiSQL etc) that rely on the `mysql_native_password` won't be able to connect because of this...chrisshennan.com
You can try second solution with switching given user authentication method.
Maybe XAMPP is outdated (newest version uses PHP 8.2, not 8.4), but at least they switched from MySQL to MariaDB:
XAMPP Installers and Downloads for Apache Friends
XAMPP is an easy to install Apache distribution containing MariaDB, PHP and Perl.
www.apachefriends.org