Mysql link in control panel

Submitted by rjrsinc on Mon, 11/22/2010 - 10:36 Pro Licensee

I seem to have lost the mysql 'manage databases' link in the user interface, probably a long time ago. I have a client that needs access to it, and I can't seem to find where to switch it on so that they get the link. Can the link be enabled on a domain-by domain basis? some of my clients are just not savy enough to have access.

Status: 
Closed (fixed)

Comments

Submitted by andreychek on Mon, 11/22/2010 - 10:40

Howdy -- you may want to look into two things.

First, if you go into Edit Virtual Server, make sure that the "MySQL login enabled" feature is enabled.

Second, in Administration Options -> Edit Owner Limits -> Allowed capabilities and features, make sure "Can manage databases" is set for that user.

After that, your user should see an "Edit Databases" link on the left when they log into Virtualmin as the Virtual Server owner.

Submitted by rjrsinc on Mon, 11/22/2010 - 10:59 Pro Licensee

They can now create or delete databases with the 'Edit Databases' link on the left side, but the ability to manage tables with the 'manage database' button is not displayed on the right. Just the 'Delete Selected' button is showing.

Submitted by andreychek on Mon, 11/22/2010 - 13:14

Well, let's start here just to make sure this isn't related to the problem -- in Administration Options -> Edit Owner Limits -> Allowed capabilities and features, is the "Can manage databases" option enabled for that particular user?