Hi Guys, I have a situation where I have to allow my friend to access my db but I don't want her to access my cpanel. So I am looking for a script which acts like phpmyadmin and can be installed right into your root or site folder. Your advice is really appreciated. Thanks, Thunder
You can use a desktop application like Navicat. They offer a free personal version and a free trial. http://download.cnet.com/Navicat-Free-MySQL-GUI-Lite/3000-10254_4-10756198.html There's also MySQL's GUI tools: http://dev.mysql.com/downloads/gui-tools/5.0.html These are both desktop applications. Make sure you set your permissions accordingly, as you will need to grant remote access on your database to use these.
if you friend wants a phpmyadmin kinda web interface.. you can install a copy of phpmyadmin and create a username for her to access the interface,. i always have a private PMA installation in my servers apart from what cpanel offers..
Grab a copy of phpMyAdmin and place it in your public_html folder. Set the config file correctly, then, give the person the link. You should have already created the database with a different user name and password than your cPanel account, so, you can just give those credentials to your friend, and that will only allow them access to that one particular database.