access phpmyadmin without cpanel login

[crazyaboutlinux]

Hi there,

I have got many emails regarding access of phpmyadmin without cpanel login.

Here is the latest one

Hi, i have a friend who need put some codes in my mysql database, i have created a db and username/password, but if i give to him the url /http://www.mydomainname.com:2082/3rdparty/phpMyAdmin/index.php the browser ask for CPANEL login and password, i just need the direct URL to phpmyadmin, so my friend can setup the db without the cpanel admin account.

and usual i have replied to this client that use mysql query browser tool to connect mysql database.

But many of our clients wants this feature enabled in cpanel so is there any chance for this feature ??

is there any one who needs this ?? +1 to this...

[Infopro]

Setting up an install of PHPMyAdmin (password protected of course) for this user to use temporarily is pretty easy to do.

The friend in your post could also work on his own database and export those changes to an .sql file that your client could import on his own as well.

Personally I do not agree that this would be a needed Feature. But thats just me.

[PlotHost]

Personally I do not agree that this would be a needed Feature. But thats just me.

+1 - I think the same .

Just extract the phpmyadmin files to a directory .. easy job. Or you can use a software like sqlyog.

[crazyaboutlinux]

could you explain this "Just extract the phpmyadmin files to a directory"

[cPanelJared]

could you explain this "Just extract the phpmyadmin files to a directory"

I am not sure what you do not understand. phpMyAdmin is a PHP application, just like a blog or forum or shopping cart. All you need to do to install your own phpMyAdmin for a site is to download the archive of the phpMyAdmin version you want, extract the archive to the site's public_html directory, and follow the rest of the install procedure in the phpMyAdmin documentation. By doing this, there is now a phpMyAdmin for that site only that can be accessed without logging into cPanel.

phpMyAdmin is just site software. We happen to distribute it with cPanel, but there is nothing that prevents you from installing another copy of phpMyAdmin on your own cPanel account.

[cPanelDavidG]

could you explain this "Just extract the phpmyadmin files to a directory"

Install phpMyAdmin like you would any PHP application (e.g. WordPress, if you were doing it from scratch).

[cPanelDavidG]

For those that want to create an additional cPanel user that only has access to phpMyAdmin, here's the request you can voice your input on: http://forums.cpanel.net/f145/multip...3-a-77145.html

This thread seems to just be about how to install phpMyAdmin outside cPanel so I'm going to move it accordingly.

[PlotHost]

could you explain this "Just extract the phpmyadmin files to a directory"

I wanted to say to install phpmyadmin...

[crazyaboutlinux]

phpmyadmin is there in cpanel but it asks cpanel username & password

[crazyaboutlinux]

i have managed to setup phpmyadmin on my centos vps

but when i visit http://myserverip/phpmyadmin or http://mydomain.com/phpmyadmin

i got this message

Not Found

The requested URL /phpmyadmin was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at mydomain.com Port 80

here how i setup phpmy admin

    $ su -
    # cd /var/www/html
    # wget -c http://prdownloads.sourceforge.net/phpmyadmin/
    phpMyAdmin-2.11.3-english.tar.gz?download
    # tar xvfz phpMyAdmin-2.11.3-english.tar.gz
    # mv phpMyAdmin-2.11.3-english phpmyadmin
    # cd phpmyadmin
    # cp config.sample.inc.php config.inc.php
    # vi config.inc.php
    :
    $cfg['Servers'][$i]['auth_type'] = ‘http‘; # default is cookies
    :
    # service httpd restart

[cPanelTristan]

Is this a cPanel machine? If so, your main IP or hostname is likely being served from /usr/local/apache/htdocs folder instead.

[Infopro]

i have managed to setup phpmyadmin on my centos vps

...

I would never have suggested installing it like that.

As a normal user, you can upload/install phpMyAdmin to a directory on the account, for that one user.

EX: upload here: crazyaboutlinux/home/public_html/privatedirectory/

Password protect that directory!

Edit the config.inc.php to connect as that user, to the databases that user owns.

[crazyaboutlinux]

I would never have suggested installing it like that.

As a normal user, you can upload/install phpMyAdmin to a directory on the account, for that one user.

EX: upload here: crazyaboutlinux/home/public_html/privatedirectory/

Password protect that directory!

Edit the config.inc.php to connect as that user, to the databases that user owns.

Hi Infopro

That's fine, this is for the particular cPanel user & it asks for cplogin details rather than asking dblogin details. And will i have to do the same process for all existing more than 400 cPusers ???

I just want that every cPusers can access their database using their
http://so.n.so.domain.name/phpMyAdmin
DBUser : sonso
DBpass : their databaes password (Here again not cp login details) That's it!

[crazyaboutlinux]

its too easy for cP devs and i don't think so that they can not do this job.

[cPanelTristan]

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.