Lookd Everywhere for the answers, Are you ALL Resellers? I'm Not..

And I'm tired of locking my car doors and taking the keys with me when I go to the mall. And tired of locking the windows and doors to my house. And keeping an eye on my notebook sitting on the table by the door at Starbucks while I order another Latte.
:D
But seriously, InfoPro's solution will likely work.

 

The gist of the suggestion was to place all of these domains in a single cPanel account so you don't need to login as the reseller (and thus see this message, furthermore being prevented from manipulating the databases).

There is no point in combining all of these into a single account if you're going to continue to access the account using reseller credentials (e.g. user's username and reseller's password to login to a user's account as a reseller) and thus encounter the same issues.

The alternative is to leave all of these domains in separate accounts and login to each account whenever you need to do database manipulation. There is no setting that will change the behavior of resellers being unable to modify the databases of their users with only their reseller credentials.

 

Correct me if I'm wrong, but I think the point is that all of the DBs will be owned by the "fake account" user, so you will be able to manage everything (including mysql) via this login.

If you use your reseller login you'll have the same problem that you started with because the reseller user doesn't own the databases.

 

Administer the databases at https://yourhostname:2087/3rdparty/phpMyAdmin/index.php as root ?

 

I have a similar scenario to you, but with about 80-100 domains. Each one of them is setup as their own account. I use the following method to work on all accounts without doing the logout/login dance.

I keep one window open, with three tabs, logged into WHM (not cPanel) as root. In the first tab is my main WHM interface. In my second is just the WHM list accounts page, cause from there I can click on the cpanel icon for any account and have quick access to that accounts cpanel (logged in as root). In the 3rd tab is the WHM phpmyadmin (logged in as root as Diniel suggested) and from there I can do any direct work to any accounts db's.

No fuss, works well.

No fake accounts, no parked accounts, no resellers.

 

Cookie base sessions?

I have Firefox set to clear cookies when I shut it down. Otherwise, I can stay logged into a session until then. I also use different browsers for different functions. Ah, the choices in Linux. :D Can you just set up a browser for this purpose and work from book marks?

 

Add-on Domains is what we use here in a number of situations, but the excuse of having to log in and log out is a little over the top. Use an FTP program where the passwords are stored for you and there's no issue.

Then use WHM's access to the phpmyadmin if you want access to all databases (or use a remote database access program - again, store the passwords and you're all set).

The last being to use WHM and click the icon for the cPanel so you can log into each individual user control panel for adding .htaccess redirects or emails etc.

I personally keep my domains with separate logins for the most part. If one site did happen to get defaced, then it's only one site to worry about, and not ALL the sites at the same time. There's an advatage to NOT keeping all your eggs in one basket

 

If you're on a Windows box for administration use WinSCP (as root) instead of FTP. That will give you file management for everything on the server.

 

If its just managing the databases that is the hassle logging in to, and you dont mind using phpMyadmin to administer them, log in to whm as root, and phpMyAdmin is a link on the left under sql services. This will give you access to ALL tables in the server with one login.

Tom