Ubuntu 20.04 expedition install / login failed

[GSkupien]

Hello,

I have a fresh Ubuntu 20.04 server 64bit and after install the latest Expedition I'm getting "Incorrect user or password."

Apache logs:

root@expedition:~# tail -f /var/log/apache2/error.log
[Wed Feb 01 11:27:14.078549 2023] [:error] [pid 4061] [client 192.168.56.1:53280] PHP Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 22, referer: https://192.168.56.103/
[Wed Feb 01 11:27:14.078704 2023] [:error] [pid 4061] [client 192.168.56.1:53280] PHP Fatal error: Database connection failed: Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 24, referer: https://192.168.56.103/
[Wed Feb 01 11:27:16.859803 2023] [:error] [pid 4060] [client 192.168.56.1:53272] PHP Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 22, referer: https://192.168.56.103/
[Wed Feb 01 11:27:16.859979 2023] [:error] [pid 4060] [client 192.168.56.1:53272] PHP Fatal error: Database connection failed: Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 24, referer: https://192.168.56.103/
[Wed Feb 01 11:27:32.668515 2023] [:error] [pid 4062] [client 192.168.56.1:59550] PHP Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 22, referer: https://192.168.56.103/
[Wed Feb 01 11:27:32.668762 2023] [:error] [pid 4062] [client 192.168.56.1:59550] PHP Fatal error: Database connection failed: Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 24, referer: https://192.168.56.103/
[Wed Feb 01 11:27:57.175861 2023] [:error] [pid 4063] [client 192.168.56.1:33100] PHP Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 22, referer: https://192.168.56.103/
[Wed Feb 01 11:27:57.178667 2023] [:error] [pid 4063] [client 192.168.56.1:33100] PHP Fatal error: Database connection failed: Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 24, referer: https://192.168.56.103/
[Wed Feb 01 11:38:02.563178 2023] [:error] [pid 4064] [client 192.168.56.1:33300] PHP Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 22, referer: https://192.168.56.103/
[Wed Feb 01 11:38:02.563285 2023] [:error] [pid 4064] [client 192.168.56.1:33300] PHP Fatal error: Database connection failed: Access denied for user 'root'@'localhost' in /var/www/html/libs/database.php on line 24, referer: https://192.168.56.103/

[AGrijalba]

I had to do 2 things:

1. Configure root password.

update user SET PASSWORD=PASSWORD("paloalto") WHERE USER='root' ;

2. Reset MariaDB securization

update user set plugin="" where User='root';
flush privileges;

As of https://serverfault.com/questions/795290/admin-password-of-mariadb-doesnt-seem-to-work

Btw, I was running Ubuntu 20 in WSL2, if that matters.