Create New domen error password MariaDB

Help! (Home for newbies)
1
SYSTEM INFORMATION
Ubuntu 22.04 REQUIRED
Virtualmin 7.9.0 REQUIRED

I installed a clean Virtualmin on Ubuntu 22.04 and when I create a new virtual server, I cannot connect to the database using this password.

mysqli::real_connect(): (HY000/1045): Access denied for user 'user'@'localhost'

Every time you have to recreate the password again through the console

mysql -u root mysql

SET PASSWORD FOR user@localhost=PASSWORD("...");

service mysqld stop

And after that they will only be able to connect to the database again

How can this be fixed?

2

We have added support for keeping default MariaDB socket authentication but we forgot to update the message in config check. It will be fix in the next minor Virtualmin release.

You shouldn’t have set MariaDB root password really. But if you did, you should have done it using Webmin / Servers ⇾ MariaDB Database Server module. Because, if you set the MariaDB root password outside of Webmin, the module won’t simply know how to connect to the database.

3

2023-04-06_21-11
2023-04-06_21-111340×781 66.7 KB

I didn’t set a password. If you set the root password. Then after restarting the server. MariaDB just stops running

4

If after rebooting the system (server) using reboot command, MariaDB isn’t starting automatically you can fix this by running the following command:

systemctl enable mariadb
5

2023-04-06_21-11
2023-04-06_21-111786×785 68.8 KB

aaa
aaa1335×875 27.4 KB

Yes, it starts with a password now. But the password still doesn’t work until I specify the password for the user in the console

SET PASSWORD FOR user@localhost=PASSWORD("...");

6

phpMyAdmin doesn’t work because you need authenticate. You should set root password for MariaDB in Webmin module for phpMyAdmin to work.

@Jamie, I’m afraid leaving out Unix authentication may confuse some users. We should make it optional in wizard!

7

No. They aren’t trying to authenticate as root in phpMyAdmin, they don’t need a root password set!

8

No more options in the wizard!

9

A user won’t be able to authenticate in phpMyAdmin with root user if MariaDB socket authentication enabled!

It isn’t a new option. We already have it. We just need to say instead of Leave unchanged, something like Leave Unix socket authentication enabled (and probably not recommend it).

I mean in here:

image
image2038×598 49.2 KB

10

Sorry, but there is no such option in the latest version of the installation. In previous versions, there was such an option. But not the last one. I noticed it right away. That is, you cannot set the MariaDB password during installation.

As for phpMyAdmin, I installed it separately from the phpMyAdmin website.

11

They aren’t using the root user! Look at the screenshot!

12

If so, then the issues are completely unrelated.

If a user cannot authenticate using that given username, then the password for this particular user is not correct or permissions are off.

Either way, I’m pretty confident that it isn’t Virtualmin issue. It works flawlessly for me in all possible tests using clean install.

13

Hello,
Hello,
I can confirm, I’ve just done a new debian installation of virtualmin and we don’t have a choice at this stage, just the message:

“MariaDB is using Unix socket authentication for the root user, so the password cannot be changed.”

14

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.