php - 应用程序错误 #400 [错误 :2045] [error:1045] in MantisBT (Ubuntu 18. 04)

Question

更新后(通过 -apt update 和 apt upgrade)访问安装 MantisBT 变得无用。数据库和用户完好无损。通过 SSH 访问服务器 (VPS) 是可用且完整的。

The connection to the database has failed. The error returned by thedatabase was # 2054: The server requested authentication methodunknown to the client Use the «Back» button in your web browser toreturn to the previous page. There you can correct the problems thathave been identified in this error notification or select anotheraction. You can also click on an option in the menu bar to go directlyto a new section.

phpmyadmin 错误:

2054 - The server requested authentication method unknown to the client

mysqli_real_connect(): The server requested authentication methodunknown to the client [caching_sha2_password]

mysqli_real_connect(): (HY000/2054): The server requestedauthentication method unknown to the client

Ubuntu 18.04.2 LTS

版本:18.04

PHP 7.2.15-0ubuntu0.18.04.1(cli)(内置:2019 年 2 月 8 日 14:54:22)(NTS)

mysql Ver 8.0.15 for Linux on x86_64 (MySQL Community Server - GPL)

服务器版本:Apache/2.4.29 (Ubuntu)

我修改了MySQL配置:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'rootpassword'

但我收到以下错误:

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.

尝试更新 MySQL 实例时:

mysql_upgrade: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) while connecting to the MySQL server

升级过程遇到错误，不会继续。

Error in access page MantisBT

Error in phpmyadmin

Answer 1

以root用户登录MySQL控制台:

mysql -u root -p<password>

运行以下代码:

ALTER USER root IDENTIFIED WITH mysql_native_password BY 'NEW PASSWORD';

您必须将“NEW PASSWORD”更改为您的新密码，然后尝试登录。

希望这会有所帮助。