jimlongo

Well-Known Member
Mar 20, 2008
237
16
68
Hi, logged into phpmyadmin from WHM 11.40.06 as root.
There is no longer a USERS tab.

Thanks.

Screen Shot 2013-10-16 at 12.40.49 PM.png
 

jimlongo

Well-Known Member
Mar 20, 2008
237
16
68
Still not there after the 11.40.09 update, which now has phpmyadmin 4.08
 

jimlongo

Well-Known Member
Mar 20, 2008
237
16
68
Thanks,

I don't understand - it's still in phpMyAdmin. Do you mean Cpanel has removed it?

If you're referring to the WHM>SQL>Database Map Tool it's pretty limited. It doesn't show all users, permissions, etc.,

For instance I have a user pma who is the user assigned to the phpmyadmin database, can't find that user anywhere.
 

jimlongo

Well-Known Member
Mar 20, 2008
237
16
68
Thanks, but that still doesn't help with administrative users like pma. And it's a pain to have to navigate to individual cPanel interfaces instead of being able to deal with all of them from WHM.
 

frankk27

Registered
Dec 22, 2013
1
0
1
cPanel Access Level
Root Administrator
Yeah, this feature should have never been removed. This database mapping tool doesn't allow you to set privileges at the table or view level. Both of these features could be used together. For some people that use WHM to manage all of the sites and aren't resellers, it's nice to be able to create users that have select access to a few tables only so you don't have to supply write permission to an entire database.
 

jacampbe

Active Member
Mar 19, 2008
30
0
56
Does this mean that we can no longer manage mysql privileges in phpMyAdmin ?
I don't even see a way to list the users/privileges in phpMyAdmin. Selecting Check Privileges on the Databases tab doesn't seem to do anything.
 

jacampbe

Active Member
Mar 19, 2008
30
0
56
Is there no way to do it from WHM ?
I have a number of MySQL accounts that are not hosting websites - ie. they are not cPanel accounts. How are the privileges for those accounts to be managed ?
 

jacampbe

Active Member
Mar 19, 2008
30
0
56
Okay, I will consider installing a standalone instance of phpMyAdmin.
Before going down that path, are you aware of any co-existence issues with running both standalone and WHM/cPanel instances of phpMyAdmin ? Do cPanel have anything documented in relation to possible issues and workarounds ?
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,902
2,228
363
cPanel Access Level
DataCenter Provider
Twitter
Okay, I will consider installing a standalone instance of phpMyAdmin.
Before going down that path, are you aware of any co-existence issues with running both standalone and WHM/cPanel instances of phpMyAdmin ? Do cPanel have anything documented in relation to possible issues and workarounds ?
A standalone version of phpMyAdmin is installed the same way you would install any other script on an account. It's not something that cPanel would support, but it's usage should be fairly straightforward. It should not interfere with the phpMyAdmin provided by cPanel. You may want to password protect it (the directory it's installed in).

Thank you.
 

dotfleck

Registered
Mar 11, 2010
2
0
51
It is a pain to do now, and I do agree that we should be able to access all users through WHM's phpAdmin, as in the not so distant past. I manage all of the domains on my servers. We create special, limited privilege users only for mysql, used for script access. The WHM Database Mapping Tool is useless. But there are some workarounds to the PHPAdmin limitations that CP has placed on WHM.

If you are logged into WHM w/ root privileges, you can see the users for each table, and their privileges by clicking on the db, and then a table. You will now see the privileges tab within the table view navigation. You could use the information shown there to create an SQL Grant request, to edit a user's privileges (under the SQL tab). Of course this has to be looked at for each table in each database, because the privileges tab is not available in the table overview for the database. That's where the "pain" comes in. It only appears in the table view. There is also the "add user" link there. I haven't tried it in this scenario.
 

OooLong

Well-Known Member
Mar 16, 2011
105
1
68
cPanel Access Level
Website Owner
Why the heck was the ability to Create user and edit privilidges remove from PhpMyAdmin in the first place?. The task of managing MySql is a pain in the ass now with this limitation cPanel place on PhpMyAdmin. Why was this limitation implement in the first place? was there a benefit? All I get so far is frustration and pain in the rear end for us end user. Please put this feature back so we don't have to install a stand alone PhpMyAdmin. Thank You.