Where is the best place to put phpmyadmin
so that I can use it for any of my website mysql databases ?
I have been using the built in database management tool but there are a few
things that would be much quicker with phpmyadmin.
With cPanel it is already set up, so I am not sure where I should put it to run on my VirualMin setup.
Will I need to supply it with my root admin user and password ?
Several years ago this was the default on my server. Installing phpMyAdmin under any domain could access all domains if the root user and password were used. I don’t know if that’s because I accidentally configured MySql for user root to be able to access all databases, but that might be the place to start.
I would very much like to know how to do this too, and perhaps it could also be added to the document wiki?
That works for each user, but how can I set it up so that I can log in as “root” and get access to all accounts. I have the “allow root = yes” already set, but it still doesn’t work.
I’ve set up root to have access to all databases under the MySql panel, both with localhost and with 127.0.0.1 and neither of those permissions worked either.
Yes, it does work. I had to refresh my memory of the MySql Admin password. For others, that can be found under "Webmin -> Servers -> MySql -> “Change Administrator Password” which also shows the current password.