I've managed to run the command for updating the data after several attempts with:
$ sudo mariadb-upgrade -p
$ sudo systemctl restart mariadb.service
The password was correct but it still failed.
]]>a few hours ago as I updated with pacman my packages I saw these lines:
warning: directory permissions differ on /usr/lib/mysql/plugin/auth_pam_tool_dir/
filesystem: 700 package: 755
:: MariaDB was updated to a new feature release. To update the data run:
systemctl restart mariadb.service && mariadb-upgrade -u root -p
I tried to run the last line, but I got an error:
Enter password:
FATAL ERROR: Could not open or create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers data directory, errno: 13 (Permission denied)
Note that mysql_upgrade should be run as the same user as the MariaDB server binary, normally 'mysql' or 'root'.
Alternatively you can use mysql_upgrade --force --force. Please check the documentation if you decide to use the force option!
Then I found this: https://seclists.org/oss-sec/2020/q1/55 and I was wondering if there is a security issue.
The output of:
sudo systemctl status mariadb.service
looks normal, MariaDB is active and running.
Could someone please give some advice, how should I proceed?
]]>