After updating (through -apt update and apt upgrade) access to the installation of MantisBT has become useless. The databases and users are intact. Access to the server (VPS) through SSH is available and intact.
The connection to the database has failed. The error returned by the database was # 2054: The server requested authentication method unknown to the client Use the «Back» button in your web browser to return to the previous page. There you can correct the problems that have been identified in this error notification or select another action. You can also click on an option in the menu bar to go directly to a new section.
Error in phpmyadmin:
2054 - The server requested authentication method unknown to the client
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
Ubuntu 18.04.2 LTS Release: 18.04 PHP 7.2.15-0ubuntu0.18.04.1 (cli) (built: Feb 8 2019 14:54:22) ( NTS ) mysql Ver 8.0.15 for Linux on x86_64 (MySQL Community Server - GPL) Server version: Apache/2.4.29 (Ubuntu)
I modified the MySQL configuration:
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘rootpassword’
but I get the following error:
ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 51, found 50. Created with MySQL 80013, now running 80015. Please use mysql_upgrade to fix this error.
When trying to update the MySQL instance:
mysql_upgrade: Got error: 1045: Access denied for user ‘root’@‘localhost’ (using password: NO) while connecting to the MySQL server Upgrade process encountered error and will not continue.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $200 of credit to try our products over 60 days!