This is an automated archive.

The original was posted on /r/debian by /u/lykwydchykyn on 2023-08-07 20:46:18+00:00.

I have a server running a single PHP application that uses mariadb. After upgrading to bookworm, I can’t login to mariadb even as root. I just get permission denied.

Things I’ve tried:

  • Using socket authentication explicitly
  • With and without a password
  • using the mysql user account
  • using sudo or from a root shell
  • UPDATE mysql.user SET plugin='' WHERE user='root' – got from a stackoverflow, but says column plugin is not updatable.

I managed to add the --skip-grant-tables flag to startup and got in that way, but I can’t update the grant tables when I get in that way so I can’t set a root password. Obviously not a long-term solution to leave it that way.

Strangely, it seems like the PHP application I’m running can access the db, but if I try to login interactively with its credentials I get permission denied.

Any ideas?