Phpmyadmin, root permissions and view all databases

[o_antonio_o]

I try to accommodate hestiaCP for my use, but I have problems that I can’t solve.
I need to be able to enter phpmyadmin with all root permissions and have all the existing databases in view.

I have tried creating a new user with root permissions, but when I log in it comes out empty.

Is there any way to get what I need?

[skorpions2000]

By default, the root password is not set, and you cannot use root because the corresponding rules are set. Most likely, not allowing the user to use root is safer than allowing =)
In your path, you can set a password for the root account and allow logging with a password. Don’t forget to tell the HestiaCP control panel your new password, otherwise it will refuse to work with the database =)

These configs will be useful for studying this issue.
/usr/local/hestia/conf/mysql.conf
/usr/local/hestia/conf/.mysql.localhost

Have a nice day

[o_antonio_o]

I did not understand anything! and I think I did not explain myself well.

HestiaCP v1.7.2 (in case it’s important)
mariaDB v10.11.2 (in case it’s important)

1 - mysql.conf & .mysql.localhost You already have root and password.
(Also, this password updates itself when I change it from the control panel edit/server/ Databases > passw)

• no puedo logearme en phpmyadmin con root (para ver TODAS las bases de datos creadas)

2 - I try the trick:
mysql> CREATE USER ‘My-root’@‘localhost’ IDENTIFIED BY ‘new-passw’;
mysql> GRANT ALL PRIVILEGES ON . TO ‘My-root’@‘localhost’ WITH GRANT OPTION;

• I can log in with My-root, but I don’t see the user databases.

I understand from your answer that surely you know how I can achieve my objective, but there is nothing more that I can understand in it.
I don’t need to be reminded about safety, I just need to meet my goal. At WHM I work like this and I don’t have the ability to learn another way of working quickly and easily.

new related queries:

a - edit/server/ Databases > ‘Single phpMyAdmin signup’
What is this option that is not documented for?

b - It would also be nice if the clients from the user account could see all their own databases and not have to log in one by one.
I don’t see it as very efficient forcing the client to be logging in continuously to work between their own databases.

• Is there a way that the user can log into phpmyadmin and see ALL their databases?

Thank you very much for your interest in helping me.
have a nice day

[o_antonio_o]

mysql> CREATE USER 'My-new_user'@'localhost' IDENTIFIED BY 'passwd';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'My-new_user'@'localhost' WITH GRANT OPTION;

I managed to do it by successfully creating a new user and giving it privileges.
The problem with the first attempt with this technique was bad writing, I missed the asterisks between the .

Do not waste time trying to give root access directly, for me it was impossible, I needed to create a new user as indicated above.

The problem that users will have to log in to each database they have remains unresolved and this is undoubtedly the worst.
Not to mention the impossibility of reusing users-db.

I will continue investigating ‘by myself’