Maria DB security settings issue

[NoraNemet]

The error:

Now we'll go ahead to apply MariaDB security settings...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
An error occurred on line 272 with exit status 0

Resolutions tried:

1. Adjusting MariaDB Authentication Plugin - Updated the plugin column in the mysql.user table to mysql_native_password for the root user. Cleared the authentication_string or password field for the root user.
2. Remove and recreate root user without password
3. Safe mode, disable authentication & flush privileges
4. Modified /etc/mysql/my.cnf - [mysqld] skip-grant-tables skip-networking
5. Fresh installation of Maria DB (purge etc)
6. Modified installer script to start Maria DB in safe mode without PW (line 270-290)

I'm running this as a non-root user on Win 11 (Ubuntu 22.04.5).

Thanks for your help!

[NoraNemet]

Solved by stopping the MariaDB process and removing all packages, config files, deleting all users and the installer worked.

[ayosafacundo]

Had this exact problem with my proxmox fresh lxc with ubuntu 24.04. It was solved by just pressing enter multiple times before it accepted the empty password. It asked me for the password a total of 4 times.