A couple oddities with the MySQL webmin module and the Virtualmin mysql integration: The databases don’t appear!
In the webmin module, the index page says
"No MySQL databases were found on your system."
If I go into the "Database permissions" section, it lists all of the databases.
If I go into Virtualmin, the MySQL setup passes the configuration checker, but it doesn’t show any of the user’s databases, even though they were created and I can view them via a tool like phpMyAdmin.
When you log into Virtualmin, you’ll see a select list on the top-left containing all the domains in Virtualmin. If you choose one that has a database associated with it, you should get an “Edit Databases” link listed just a few lines under the select list (immediately under “Edit Mail Aliases”).
Once you click that, do you see any databases listed there?
-Eric
Oh, wait. I see that you said, “If I go into the “Database permissions” section, it lists all of the databases.” Which is giving me maybe a vague notion that the MySQL module isn’t actually configured to login to MySQL as a “root” level user, or the database permissions aren’t granting that user access to all of those databases (probably the latter, now that I think about it). The Webmin module only displays databases the user is allowed to work with. Is phpMyAdmin logging in as the same user as the MySQL module in Webmin?
So, I’m guessing something wrong in the permissions. But I dunno. I’m, by no means, a MySQL expert.
If you log into Virtualmin, then click Webmin -> Servers -> MySQL Database -> Module Config, what user shows up as the "Administration Login"? That should be "root".
You might also want to verify that the root MySQL password in Virtualmin is correct (though, if it weren’t, I suspect you’d be seeing permission denied / incorrect password errors).
-Eric
I’ve set it there. My databases don’t appear in the MySQL module either, even though I can edit databasee/user/host permissions and do assorted other things.
I have just started experiencing this issue. The link to the bug report you provided doesn’t work anymore and I can’t find the issue in the tracker. Do you know where it has gone, or whether it was fixed?
Hmm, I don’t seem to be able to find that bug report either anymore (the bug tracker had changed a few years back, which threw off the links), and I haven’t heard of that issue again in the 4 years since it had been mentioned here
Do you think you could open up a new forum thread, and describe some details about what you’re seeing, and when it started occurring?