Application error #400 [error:2045] [error:1045] in MantisBT (Ubuntu 18.04)

February 16, 2019 712 views
MySQL PHP Ubuntu 18.04 Databases

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

mysqlirealconnect(): The server requested authentication method unknown to the client [cachingsha2password]

mysqlirealconnect(): (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 mysqlnativepassword 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.

1 Answer

Hey friend,

Try creating /root/.my.cnf file that contains this information:

[client]
user=root
password=yourpasshere

Replace the last part with your MySQL root user password. Then try “mysql_upgrade” again.

Jarland

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!