These forums are locked and archived, but all topics have been migrated to the new forum. You can search for this topic on the new forum: Search for how to assign a new database to phpmyadmin? on the new forum.
Web Hosting and Cloud Computing Control Panels
sorry, I've not come across that problem before, virtualmin usuually creates the database for me when creating a domain.
there is a databases link on the top of the phpmyadmin, can you select that and see if it is thus listed ?
No Briand, it is not listed inside phpmyadmin. I know a solution which is to remove phpmyadmin script and install it again and choose both database. However, I think there must be another way to assign new database to phpmyadmin.
anybody knows this?
It's a permissions issue. You'll need to be logged in as the main server admin/root user. Then:
Virtualmin->System Settings->MySQL Servers->Manage->Select the database you want->
Databases -> use the drop down to select the right one Username -> set the username to the one that needs the permission Hosts -> more than likely will be localhost Permissions -> select the first one then holding shift, select the other permissions
You actually have to type in localhost or the host and select the permissions. When I left those alone it gave me an error, best to just type them in/select them.