phpMyAdmin Not Available w/Root Login

[Frank Hagan]

This is new in the upgrade of Cpanel. I routinely manage my customer's sites for them, and use phpMyAdmin fairly often; they know when I've been logged in, and I don't have to know their passwords. But the new version of Cpanel won't allow you to manage the MySql databases using the reseller login. You get this error message:

This feature is not available while logged in with root override. You are logged in with the root, or reseller's password. Please login with this user's account password.

You have to log in with the username and password assigned to the account to use phpMyAdmin.

[AndrewT]

It has always been like this. You can only access phpMyAdmin when logged in directly with the cPanel username and password.

[Frank Hagan]

It has always been like this. You can only access phpMyAdmin when logged in directly with the cPanel username and password.

Really? I need to check my Ginko supply then, because I could have sworn I've managed customer sites via phpMyAdmin!

[cathode]

I confirm, it's always been like this...

[djn]

Sad but true. I suppose you should be able to set up your own PhpMyAdmin in a folder of your webspace and reach that databases manually editing the config file to ask you for an username and password.
The line to edit is this:
$cfg['servers'][$i]['auth_type'] = 'http';
(with $i being '0' if localhost is the first - and probably only - server configured in the array). Uses standard HTTP Auth, so to switch user you have to restart your browser (unless it's Firefox, which has a 'Clear Http Auth' extension).

[AndrewT]

You would still have to know the cPanel user's password or temporarily create a separate MySQL user via their cPanel (using your reseller login) with access to the database that you want.

Having said that, phpMyAdmin is also directly available via http://cpanel##.gzo.com/phpMyAdmin/

[djn]

As long as any existing database user is granted all privileges for a database one should be able to log in as such and manage it. Usually it's me setting up the databases for my customers, so I know the username and password. Failing that, the File manager in Cpanel could be used to take a peek at the config file of the script that uses the database. Like the reseller login, this helps saving the day when I'm somewhere away from my password archive and a customers needs something fixed in a hurry...

[Frank Hagan]

Yeah, that's my concern. Its not always a problem because usually I have a copy of their original password. So unless they have changed it, I can log in as them if I have to. But when I'm away, like I am this week, its a bit more difficult.