how to assign a new database to phpmyadmin?

5 posts / 0 new
Last post
#1 Mon, 01/21/2019 - 04:46

how to assign a new database to phpmyadmin?


When I install Phpmyadmin script, virtualmin allows me to select database to manage with that script. However, later I create a new database not by using phpmyadmin, then how can I see it inside phpmyadmin? How can I assign a new created database to old phpmyadmin script? Thank you

Mon, 01/21/2019 - 05:18

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 ?

Mon, 01/21/2019 - 07:35

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.

Wed, 01/23/2019 - 23:50 (Reply to #3)

anybody knows this?

Wed, 02/06/2019 - 06:01

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.

Topic locked