Submitted by singhdd on Fri, 03/11/2016 - 02:04
1) Install phpmyadmin
2) then add new database
3) again login to phpmyadmin
4) it doesnt show newly added database
5) Now uninstall phpmyadmin and reinstall it
it shows the last added databases but again wont show any databases added after installation.
Files:
Status:
Active
Comments
Submitted by andreychek on Fri, 03/11/2016 - 09:21 Comment #1
Howdy -- hmm, that's an unusual issue.
What phpMyAdmin version is it that you're using there?
Also, could you try logging into MySQL as the Virtual Server owner on the command line? That can be done by logging into SSH as that user, then running "mysql -u USERNAME -p".
Then, type "show databases".
Do all the users databases show up as expected?
Submitted by singhdd on Fri, 03/11/2016 - 11:25 Comment #2
phpmyadmin version is latest. Installed from "Install Scripts" and is regularly updated.
yes the command line and Adminer (https://www.adminer.org) works fine and show every db as soon as I create a db from virtualmin.
Just another request can you kindly create a script for adminer. Its just a single php. Scripts are much better for automation.
Submitted by JamieCameron on Fri, 03/11/2016 - 20:55 Comment #3
When you installed phpMyAdmin, did you select specific databases that it would be allowed to access?
Submitted by singhdd on Fri, 03/11/2016 - 23:19 Comment #4
No I selected "All Databases" option. But I think it allows access to only databases available at that time.
Submitted by JamieCameron on Fri, 03/11/2016 - 23:58 Comment #5
There's nothing in Virtualmin itself that would do this - perhaps you need to refresh the page in phpMyAdmin or logout and login again to see the updated DB list?
Submitted by singhdd on Sat, 03/12/2016 - 06:43 Comment #6
I already tried logging out and again login. I am on Ubuntu 14.04 and Webmin 1.791 and everything updated. Its not only on one server but all the servers I installed Virtualmin on.
Submitted by singhdd on Sat, 03/12/2016 - 06:44 Comment #7
Submitted by JamieCameron on Sat, 03/12/2016 - 15:34 Comment #8
Another thing to check is which user you are logging into phpMyAdmin as - is it the domain owner (who will always have access to all databases), or another mailbox user (who might not).
Submitted by singhdd on Sun, 03/13/2016 - 08:39 Comment #9
I am logging in as domain owner.
Submitted by JamieCameron on Sun, 03/13/2016 - 11:25 Comment #10
Which version of phpMyAdmin did you install?