Lost privileges on users in phpmyadmin with the phpmyadmin user after updating Debian 12 to 13

[kurgans]

Good morning, everyone.

First, my apologies. I don't speak English and I use a translator, which may cause some misunderstandings.

As the subject line indicates, after updating a Debian 12 to 13 VPS, I see that the phpmyadmin user has lost the privileges it had to manage users, so new users cannot be created outside the panel to assign them to existing databases.

I have manually created a user called kurgans with all the privileges as root, but user management is still not accessible.

I have looked at the phpmyadmin conf files and they appear to be correct.

$cfg[‘Servers’][1] = [
// Authentication type
‘auth_type’ => ‘cookie’,

However, it does not respond to either the user created by default in the panel installation or the user created directly on the mariadb console.

Has anyone noticed this issue after updating and/or been able to solve it?

Thank you.

[Alexander]

Hello,

I am not aware of that the dist-upgrade from 12 to 13 removes the GRANT option from root accounts. If this will generally be the case, i guess there would have been some messages in the forum about this.


To fix your issue and create an account, which is able to use the GRANT command and manage other user privileges, you have to create it like this:

Code: Select all

GRANT ALL PRIVILEGES ON *.* TO 'kurgans'@'localhost' IDENTIFIED BY '<YOUR PASSWORD>' WITH GRANT OPTION

With this account you should be able use the user management.

[kurgans]

Good morning

If I understand what you're saying... I have several environments updated from Debian 10 to 13 through the panel and have never had any problems.

But I don't know what's wrong with this one. I already tried what you suggested, and it didn't work. That's why, after looking into it and thinking about it a lot, I decided to post it on the forum to see if anyone else had had a similar problem and could fix it if they posted it.

The thing is, this VPS only has one Angular app and a couple of reverse proxies for some URLs, nothing that could generate that action on the privileges of mariadb users.

The machine was set up on Debian 12 with the latest version of the panel. The panel environment works correctly... it always has. Since I needed to update Java to version 21 and not complicate things too much, I used the Debian 12 to 13 script as usual, and that's when it stopped letting me access users, which is the strange thing.

It's a very small environment. I'm going to redo it directly in Debian 13, make sure phpmyadmin works correctly, and then deploy the app to see if downloading a package can modify anything.
I didn't mention anything about virtualization because it's ESXI and I have several, and there are no problems between them.

I'll get back to you with news once the system is set up again.

Thanks for everything.

[kurgans]

Good afternoon

Apologies to everyone for my delay in continuing with the thread... work has kept me quite busy lately

As I mentioned, I have reinstalled a new server. I haven't added anything yet, just to verify the phpmyadmin permissions in Debian 1. The result is the same, although the option to create a user outside the panel and assign them to a database or another database so that both users can share access has been lost.

Here's a screenshot of Debian 12 and another of Debian 13 where you can see that this option is not available.

Thank you all and my apologies for the delay these past few days.

s2

[Alexander]

With which user you were logged in as taking the screenshots?

Still cannot reproduce this. Should i take a look at phpMyAdmin on your server?
(In this case, just send me the server IP + SSH port via private message and enable support access (KeyHelp Admin area -> Configuration -> Support Access)