|
| MySQL Databases not displayed; MySQL working fine 2008/10/11 07:44 |
|
|
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.
Any idea what could cause this?
|
|
|
|
The administrator has disabled public write access. |
andreychek (Moderator)
Posts: 861
|
| Re:MySQL Databases not displayed; MySQL working fine 2008/10/11 10:50 |
|
|
Howdy,
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
|
|
|
|
The administrator has disabled public write access. |
|
| Re:MySQL Databases not displayed; MySQL working fine 2008/10/11 10:53 |
|
|
No. I see any postgres databases I have, but none of the mysql dbs.
|
|
|
|
The administrator has disabled public write access. |
Joe (Admin)
Posts: 4213
|
| Re:MySQL Databases not displayed; MySQL working fine 2008/10/11 11:45 |
|
|
You have more than one installation of MySQL, perhaps?
|
|
|
|
The administrator has disabled public write access. |
|
| Re:MySQL Databases not displayed; MySQL working fine 2008/10/11 11:46 |
|
|
uhhhhhh not that I'm aware of?
|
|
|
|
The administrator has disabled public write access. |
Joe (Admin)
Posts: 4213
|
| Re:MySQL Databases not displayed; MySQL working fine 2008/10/11 11:52 |
|
|
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.
|
|
|
|
The administrator has disabled public write access. |
|
| Re:MySQL Databases not displayed; MySQL working fine 2008/10/11 12:16 |
|
|
i've been logging in as root
|
|
|
|
The administrator has disabled public write access. |
|
| Re:MySQL Databases not displayed; MySQL working fine 2008/10/12 06:01 |
|
|
To throw in another oddity, I can view the databases of a user if I log into usermin.
|
|
|
|
The administrator has disabled public write access. |
andreychek (Moderator)
Posts: 861
|
| Re:MySQL Databases not displayed; MySQL working fine 2008/10/12 06:08 |
|
|
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
|
|
|
|
The administrator has disabled public write access. |
|
| Re:MySQL Databases not displayed; MySQL working fine 2008/10/12 06:12 |
|
|
Yes, the user is root.
I can set the root mysql information in the webmin mysql module; where do I find it for Virtualmin (GPL) ?
|
|
|
|
The administrator has disabled public write access. |
|
