Connect to MySQL with EMS MySQL Manager

[suncoast]

How do I connect to my MySQL servers/databases with EMS MySQL Manager? It asks me for the host name which i give as: (username).powwebmysql.com and i give it port 3306 but it can't connect.

what's the user name and password? I've tried an individual database username/password and that doesn't work. I'm not connecting to a specific database, im trying to connect to them all. Thanks!

[suncoast]

I am trying to connect to my mysql database and I get unknown server host errors when I try to connect

I'm using the linux command like mysql application (mysql -h host -d database -u username)

im connecting to: username.powwebmysql.com (like it says in the ops control panel)

My databases are setup because I can use phpmyadmin from the ops control panel

any ideas?

[Croc Hunter]

You cannot make remote connections to Powweb, the ports are blocked.

[edit] you only need to post your question once.

[suncoast]

oh. :S

Well thanks for the response.

[dmacminn]

You will also find, to confirm this, that the address <username>.powwebmysql.com is not routable -- it does not exist outside our protected subnet and is therefore not accessible externally.

[spamjim]

The Powweb user might be interested in SQLyog from http://www.webyog.com which uses tunneling.

http://www.webyog.com/en/sqlyog_tunneling.php

The effect on Powweb's server is similar to phpMyAdmin but you can use a more visual interface. It can also be quicker and less of a resource hog on Powweb since it does not need to render the HTML for phpMyAdmin's interface.

Of course, be sure that your connection is as secure as the one used by phpMyAdmin. Running a lot of queries through a plain HTTP connection might allow network sniffers to sniff out your MySQL data and passwords.