mariadb-10.3.22-1 error with password

[marchugo]

Today in the updates came mariadb-10.3.22-1. After installing, it requires to enter a p/w as root. After typing the p/w there's this error message:

Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

What does this error mean and how to fix it?

Even doing enter with no password gives the same error. As I understand, the database is now not protected by a password? How risky is this?

Marc.

[doktor5000]

Today in the updates came mariadb-10.3.22-1. After installing, it requires to enter a p/w as root. After typing the p/w there's this error message:

It doesn't require to enter the root passwort. What you are probably referring to is the instructions contained in /usr/share/doc/mariadb/README.urpmi which are shown during the installation/update ?

Maybe you also want to read up on this, as it has been asked before: viewtopic.php?f=7&t=13161

NOTE: MariaDB is installed without root password, it is recommended to set the
root password with the following command as soon as possible:

# mysql_secure_installation
press enter at each question except the new root password.

The initscript used to start mysql has been reverted to use the one shipped
by MariaDB. This means the following changes:

* The generation of the initial system mysql database is now done when mysql
is started from the initscript and only if the /var/lib/mysql/mysql
directory is empty (mysql_install_db). Previousely this was quite hidden and
silently done at (rpm) install time. As a consequence to this change you may
have to perform some manual tasks to upgrade the mysql system database and
such. So, doing something like this might help you:

systemctl stop mysqld.service
TMPDIR=/var/tmp mysql_install_db
mysql_upgrade --skip-write-binlog

The cluster functionalities (ndb) has been deactivated and will be removed in
future mysql versions. Oracle has a new product named mysql-cluster that
replaces the cluster functionalities.

The mysql-common-core package ships with a default /etc/my.cnf file that is
based on the my-medium.cnf file that comes with the source code.

If you need time zone data, run the following command after install:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -D mysql

[marchugo]

Thank you for the info and the link, Doktor.

I'm as puzzled as the user in that link. In the past years I always was able to harden MariaDB with a password, as is strongly required by the pop up that appears after an update of Mageia.

I didn't install MariaDB myself, it was part of the clean install of MGA 7.

I have still no idea what the error message means. I read that something changed in the installation of mysql, But why does this MGA distro still asking me to protect MariaDB?

Also, I wonder why it is advised here in the forum to leave MariaDB unprotected without a password? The warning to protect it, is strongly worded.

Maybe only on servers MariaDB is to be protected with a password? In that case I can leave it without protection, I guess?

Regards,

Marc.

[doktor5000]

Also, I wonder why it is advised here in the forum to leave MariaDB unprotected without a password? The warning to protect it, is strongly worded.

If you don't actually use MariaDB and if it's not running (as in the linked forum thread) - why protect it with a password ?