I've figured out a way to remove the action text descriptors in PMA, but it does require a local/separate web server and an instance of PMA on it that provides access to its settings. I have a two local development servers (one LAMP, one WAMP), and configured PMA on the LAMP server. Steps required:
1) In my CWH account's cPanel, I've added my local connection's IP address to Remote MySQL (this has to be done for each CWH hosting account);
2) In my local LAMP server's PMA configuration file, I've added all my CWH accounts to the "Server(s) configuration" section. I left all settings at PMA's defaults, except the following which may have an impact on remote use:
- Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['host'] = 'CWH.account.domain.name';
$cfg['Servers'][$i]['user'] = 'CWH account name';
$cfg['Servers'][$i]['password'] = 'CWH account password';
I can now use my local PMA and, from its Home screen, can select whichever CWH account - plus my local MySQL servers - I want from the "Server:" pull-down (near the top right in v2.x and near the top middle in v3.x).
Notes:
- A side benefit to doing all this is, of course, that I now have full control over PMA's configuration and no longer have to pester CWH tech support for PMA issues.
- Both of my PMA versions are a bit older than CWH's, but both work fine on the CWH-hosted databases, and I suspect there are only minor differences in the newer 3.x versions.
- WAMP's system tray facilities do not provide access to PMA's configuration. For my WAMP setup, I had to edit PMA's configuration file manually (of course, this is generally true of LAMP setups).
- To access a MySQL server on a different computer on my LAN, I had to ensure that the MySQL user account and privileges for the remote computer were set.
- I messed around with a number of things on both my LAMP and WAMP MySQL servers and the LAMP's PMA to get things working. I may have missed noting something here, so if you're trying to do this and encounter issues, let me know.
Hope this is of help to others; enjoy!