Ubuntu 20.04 expedition install / login failed

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Ubuntu 20.04 expedition install / login failed

L0 Member

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/

 

 

1 REPLY 1

L1 Bithead

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.

  • 1379 Views
  • 1 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!