phpMyAdmin User accounts error

[geniusconsult]

Login to phpMyAdmin as root user:
click on User accounts - throws error:

Code: Select all

Not enough privilege to view users.

Env version: Fresh install on Debian 11, MariaDB 10.5.19, phpMyAdmin 5.0.4deb2+deb11u1

[geniusconsult]

Also this can bellow be cause, but I have MariaDB and phpMyAdmin on other servers, and not getting that error.

Since 10.4 MariaDB uses mysql.global_priv and older versions use mysql.user tables to store user information

[myVesta]

How did you even enable "root" login to phpMyAddmin, since it's disabled by default?

[geniusconsult]

How did you even enable "root" login to phpMyAddmin, since it's disabled by default?

I did not do anything special
root@localhost is not disabled - you can use shell cli access with that user.

Just logged into phpmyadmin with root user and password from .my.cnf file
phpmyadmin use localhost and root@localhost is not disabled

Anyway, that is not issue - want to get root user to have all permissions
I even installed phpmyadmin 5.2.1 from backports repo, but nothing changed. Still can not see User accounts.

So, main thing is: myVesta create 2 db users, one for localhost other for '%' hostname, and I don't like those wildcard entries. So want to lock those users as I don't want to allow remote db access at all.

PS. consider to add some kind of rename for /phpmyadmin/ URL (ask for that during install, same as token for admin url)

[jdl]

how to fix this ?