How to prevent the root user from accessing a specific database?

Question

linux

Linux server with multiple mysql databases.
Configured phpmyadmin login as root.
Interested in whether it is possible to prevent the root user from seeing a specific database in phpmyadmin, and how to do this?

Answer 1

My free advice to you is to tie it up with access to databases under the root, this is fraught.

Answer 2

Gentlemen, you finish under the root to sit anywhere. Cherevato it. When you do not wait - bang.

Answer 3

As far as I know, root is omnipotent and such an operation is unlikely to succeed. However, I may be wrong.

Answer 4

Create a separate user with full rights to all databases except this one.

Answer 5

If you install MySQL Workbench there is user rights management. You can take root and reset his almighty rights and give him access only to certain bases. But this is fraught with loss of control over the base in general.
So for each base it is better to create a separate user. Also it is not necessary to do users which have access to all bases. And you can sit under the root is not a problem. You just need to know what you're doing. Under the root only administration. And if someone else has to come in, or this connection is from the application, then everything must have its own user.