Hey Digital Pointers, After finding this awesome forum, I started looking around a bit and came across some posts talking about phpMyAdmin alternatives (currently what I use) such as Navicat, the MySQL Query Browser, and I think Toad. I downloaded the MySQL tools, but am not having any luck connecting to my web sever. Any tips? I keep hearing about "tunneling," but not sure what that is really. Thanks!
I downloaded the Navicat trial. In the Connection box, do I give the same info as if I were logging into my site's cPanel? Host name/IP address: Can I give in http://www.whatever.com format? Port: No idea what to put here; the default is 3306 User name / Password: cPanel info? If I do use my cPanel info, I get this: 1045 - Access denied for user [my username]@[my ip and trace route] (using password: YES) Code (markup): What gives?
phpMyAdmin runs locally on the server so will connect as [my username]@localhost. To access the database from your PC you'll need to set up the privileges for [my username]@[my ip and trace route], which can be done from phpMyAdmin. Not much use unless you've got a static IP though.
Tunneling allows you to use a thick client like Navicat to connect to a database that only allows localhost connections using http. So, in Navicat's case, you upload the ntunnel php page to your web server, then use Navicat to connect to that php page instead of directly to the database server. As far as the MySQL server's concerned, it's a page from the webserver calling it, not a thick client on port 3306, which is usually restricted by your isp. hth.