access phpmyadmin without cpanel login

[crazyaboutlinux]

Hello,

I am just surprised , i have had posted this ticket at Feature Requests for cPanel/WHM i don't know how this post moved to cPanel and WHM Discussions ?

It would be good if you can move this thread Feature Requests for cPanel/WHM

Thanks in advance

[cPanelTristan]

The thread was moved out of feature requests area as the intention wasn't understood, because it isn't that you want extra users like the other feature request but that you want the database users to be able to access PhpMyAdmin as they can remotely via MySQL clients. That's a different request entirely. Had it been phrased as I noted in my prior post, I am relatively certain the intention would have been easily understood.

I think that moving this entire thread likely reduces the understanding of what is needed. It would have been better to create a new thread quoting what I stated instead (and linking to this thread so that the intention was understood):

I would like to request that cPanel database users are able to log in with the database username and password to PhpMyAdmin rather than restricting login to the main cPanel username and password for PhpMyAdmin. This will allow individual database users to manage their database independently, similar to allowing email users individual email account login for webmail. We already allow remote connections to individual MySQL databases to manage the database via the cPanel database username and password.

That's just my opinion. I've moved it back in its entirety to the feature requests area as requested.

[cPanelDavidG]

If this is a requirement for you, you might consider posting a feature request on the forum:

Feature Requests for cPanel/WHM

Otherwise, if you are unable to develop the component to function, you might hire someone to try to get that type of ability setup before any such feature is implemented:

Dev & Sys Admin Services « Application Catalog

A note for the feature request, I highly suggest being very specific that you require the following:

I would like to request that cPanel database users are able to log in with the database username and password to PhpMyAdmin rather than restricting login to the main cPanel username and password for PhpMyAdmin. This will allow individual database users to manage their database independently, similar to allowing email users individual email account login for webmail. We already allow remote connections to individual MySQL databases to manage the database via the cPanel database username and password.

If you phrase it like that, you might be able to propose a worthwhile reason for the feature to be considered.

Just FYI for everyone, that's why I linked to http://forums.cpanel.net/f145/multip...3-a-77145.html - that's precisely what that feature request is for.

This thread is either a how-to on how to install phpMyAdmin (something any moderately experienced webmaster can handle) or a duplicate of http://forums.cpanel.net/f145/multip...3-a-77145.html - I'm not sure yet judging on the content of this thread.

[cPanelBrianO]

If I understand the request correctly, some users are wanting an installation of phpMyAdmin that is not behind any sort of authentication mechanism. This installation would then just accept any valid MySQL user/password and permit access accordingly.

Be aware of the potential security implications of a public facing phpMyAdmin installation that does what you're asking.

By the very nature of providing such an installation, you essentially destroy the security of the "Remote MySQL" access hosts feature of cPanel. This would be because all requests from phpMyAdmin would originate from "localhost" and therefore any visitor to the public facing phpMyAdmin installation would be able to access any user/db that they have a valid login for. This is in contrast to the current situation where no one can speak to MySQL unless their host is in the Remote MySQL access list (or they have the account's cPanel user/password to access phpMyAdmin).

You'd have to be concerned about brute force attempts to phpMyAdmin as well since, as it stands, phpMyAdmin is not covered by cPHulkd (as cPHulkd covers the cPanel login they need presently to get to phpMyAdmin).

It's a lot of additional risk to consider.

My personal recommendation would be to, as has been suggested in this thread, install phpMyAdmin individually to the user's account in a custom location perhaps even secured behind .htaccess authentication for even further protection.

I would personally be very apprehensive about a server-wide phpMyAdmin installation that's open to any visitor to try and authenticate with being on my box.

The feature request that DavidG has linked to (cPanel Sub Users) seems to satisfy this particular request (phpMyAdmin only access) in what would be a more secure fashion. I would certainly advise continuing to post any comments or support to that particular feature request.

[cPanelTristan]

Hello DavidG,

I had read through the linked feature request and it appears to be a request for cPanel subusers for logins not for already existing and created MySQL database users who have passwords being able to specifically log into PhpMyAdmin on a machine. Again, they can remotely connect to the database to manage it as that created database user and password using a remote MySQL client, but they cannot independently log into PhpMyAdmin itself. I am uncertain how this request would be the exact same as the other one. The other request appears to be a far wider request for sub user cPanel login allowances without the narrow focus of only PhpMyAdmin. The other request also appears to require creating additional users while this request would take the existing MySQL database users and passwords and allow them access into PhpMyAdmin.

If I'm wrong, please let me know. This is why I moved it back into this area as it appears to me to greatly differ from the other feature request. If I missed this very narrow focus and very specific use case in the other thread, please link to the specific post I missed discussing it.

Thanks!

[jasoncollege24]

ok so I am a web admin for a friend's server with root access. Problem we're having is that cpanel license is expired, and the server owner/host can;'t afford to update the license right this second.

I've followed instructions here, and on the phpmyadmin website to install a version of phpmyadmin in /home/accountname/public_html/phpmyadmin

I followed all setup instructions, and finally got to a login prompt when I went to the phpmyadmin web address that I created, but I'm getting numerous errors when I'm logged in (And 1 when I'm not) None of these errors appear in the cpanel version, and far as I can tell, the configuration is the same.

Error: The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

Error: The mcrypt extension is missing. Please check your PHP configuration.

Error: The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.

What was not included in the config file i made using setup, was added from cpanel's phpmyadmin config file in order to make sure it was complete. I have some advanced knowledge, but this is the first time I've saetup phpmyadmin myself and I'm confused. I want to ensure that the configuration is the same cpanel uses, and eliminate these errors.

[cPanelTristan]

The first error about extended features is typically not important. Those features are not necessary to PhpMyAdmin functionality.

The other errors would be due to missing PHP modules when PHP was compiled. You'll need to add mcrypt and mbstring. If you cannot run EasyApache, this means you'll need to install those PHP modules manually.

[PlotHost]

You can use a software like sqlyog to connect directly to mysql server.

[Infopro]

Feature Request threads should not be support threads and visa versa.