Describe the bug

After I installed the MariaDB server I changed the root password and then tried to install phpMyAdmin. During the configuration I got the error

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

when the configuration tool tried to set up the pypmyadmin DB.

I just saw, that the same happens when I try to remove the phpmyadmin package and delete the phpmyadmin DB while doing so.

To Reproduce

1. Fresh installation MariaDB
2. Change root password for mysql
   Since it took me hours to figure out a way to do so here's a way that should work.

sudo mysql -u root mysql
UPDATE user SET plugin = "mysql_native_password", authentication_string = PASSWORD("Password") WHERE user = "root";
FLUSH privileges;
quit
sudo service mysql restart

3. Install phpMyAdmin
4. Choose to set up the phpmyadmin DB

(Or try to uninstall pypmyadmin and remove the phpmyadmin DB.)

Expected behavior

Maybe there should be a prompt for the mysql root password when installing phpmyadmin (or whenever root privileges are needed).

Temporary fix

Install phpMyAdmin prior to changing the root password of mysql.

Server configuration

• Operating system: Raspbian GNU/Linux 10 (buster)
• Web server: Apache/2.4.38 (Raspbian)
• Database version: 10.3.22-MariaDB-0+deb10u1 - Raspbian 10
• PHP version: PHP 7.3.14-1~deb10u1
• phpMyAdmin version: 4.6.6deb5 or 4.9.5deb2