Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

First time here on SF, (love SO), so hope I can get the terms right, not really a server person but here goes...

Trying to set up access to a mysql database for a separate user. Of course that's not a problem, easily set up. Separate username and password. The problem however is with my host (Hostgator, who are amazingggg), with mySQL databases, you have one master login to the PHPmyAdmin, which is automated login through cPanel. There seems to be no way to login to the myPHPAdmin interface with the separate username and password, only accessing the single PHPmyAdmin. The only way to access the PHPmyAdminwas through the cPanel, with the ONE username and password, which would then be able to see and edit all databases on my hosting account, which I don't want. I accepted this at the time when I was researching, and put the project on hold.

A few weeks ago I was installing a new wordpress installation (unrelated project), and found an old link to a wordpress plugin which enabled me to do exactly what I want to do! (Link here : http://wordpress.org/extend/plugins/portable-phpmyadmin). It uses the mySQL database information in the config.php file of the wordpess install to display PHPmyAdmin. It limits the display to the database the wordpress install uses.

My thoughts were, if this can be done by a wordpress plugin, then why not some sort of stand alone php page? I don't have enough php knowledge to hack up the plugin, but I would have thought there was something already like this out there, I just don't know what it's called or how to find it.

The support team from HostGator suggested using a desktop application to access the database, but the cPanel requires the ip address of anything that wants to access it remotely, and we don't have one (in our house). By using the wordpress installation, it uses "localhost" as the server address, removing the ip problem.

Please do edit and tag if I have explained things in a poor way.

Thanks in advance!

share|improve this question
add comment

2 Answers 2

up vote 2 down vote accepted

You can install a standalone version of phpMYAdmin yourself on your hostgator domain. Download the PHP applcation from http://www.phpmyadmin.net/.

In CPanel you can create separate users that only have access to certain databases. effectively restricting what databases they can edit. I don't believe that you can make restriction on uses at the table level thou.

Or Search Google for phpmyadmin alternatives.

One of my faviorte alternatives is SQL buddy. Its a true upload and go PHP application. it works really well and i have used it many times in the past when phpMYAdmin wasn't already installed. Its not as good as phpmyadmin but still pretty good.

There is also aerosql, I heard good things about but never used.

share|improve this answer
    
Thanks for the info. I thought you could probably do that, but wasn't sure if my host would restrict me from doing so. Will give as correct answer after I have done it. –  Relequestual Jan 9 '10 at 15:51
add comment

The standalone PHP is phpMyAdmin itself. You can download and install it yourself and configure it however you like. HostGator has just set one up with settings they like for you, but nothing prevents you from doing it too.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.