Dear Maintainer,

debian-start uses obsolate hardcoded /etc/mysql/debian.cnf. The file
will bee removed in the future. When this file exists, I get
"Access denied for user 'root'@'localhost'" with mariaDB Unix Socket Authentication Plugin.

Here is a possible fix:
--- debian-start	2023-11-17 10:22:20.020000000 +0100
+++ debian-start.new	2023-11-17 09:57:04.700000000 +0100
@@ -17,11 +17,15 @@
   . /etc/default/mariadb
 fi

You are correct in that there are still calls to
'--defaults-file=/etc/mysql/debian.cnf' in the package scripts and
that they have been deprecated.

They are obsolete on new installs. However on old installs that
upgraded from MariaDB 10.x they are still needed. We likely have to
wait for several years before removing those, and additionally there
needs to be scripts that delete/rename the all the legacy
/etc/mysql/debian.cnf files before that.

I found Sebastian's patch did not fix this for me.

A simpler change seems to have sorted it out though:

--- debian.cnf.orig     2024-05-09 12:02:59.845494238 +1000
+++ debian.cnf  2024-05-09 12:03:10.213564938 +1000
@@ -3,10 +3,12 @@
  host     = localhost
  user     = root
  password =
+protocol = socket
  socket   = /var/run/mysqld/mysqld.sock
  [mysql_upgrade]
  host     = localhost
  user     = root
  password =
+protocol = socket
  socket   = /var/run/mysqld/mysqld.sock
  basedir  = /usr

Kind regards
Vince

Hi!

Thanks for the patches!

If you think they are correct and universally should be in the
packaging, please submit a Merge Request:

https://salsa.debian.org/mariadb-team/mariadb-server/-/wikis/Contributing-to-MariaDB-packaging-in-Debian

Steps to reproduce the original issue would also be nice and help in
testing that a fix has the intended effect.

Hi!

Thanks for reporting
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1056120 and
suggestion for code fix.

Do you want to submit it as a Merge Request at
https://salsa.debian.org/mariadb-team/mariadb-server/?