PDA

View Full Version : Connecting to MySQL via program. v."Cannot find Database"

alexfierro
10-19-06, 01:49 PM
Hi, I'd like to communicate with MySql on my server with a shell program. Specifically, SSH Secure Shell. I go to Quick Connect and it asks me for host name and user name. I made a new database just for this use. So, I type in my username for the MySQL and for host I type in "mysql14.powweb.com" just like it says on the MySQL page..."Database is on mysql14.powweb.com"

it says "The host 'mysql14.powweb.com' is unreachable. It may be down..."

Please advise.
tbonekkt
10-19-06, 02:16 PM
You cannot connect to the mysql servers remotely or via shell. You have to use the global phpmyadmin installation or install one to your powweb webspace.
alexfierro
10-19-06, 02:20 PM
You cannot connect to the mysql servers remotely or via shell. You have to use the global phpmyadmin installation or install one to your powweb webspace.

But I don't want to use a php installation. I want to connect via shell.
tbonekkt
10-19-06, 02:26 PM
That's not possible - just like it wasn't on legacy.

EDIT: The only way I can think of that it MIGHT work would be via a simulated shell php script. But I doubt that works either.
alexfierro
10-19-06, 02:39 PM
Then make it possible. I don't like PHPmyAdmin. :'(

..and don't say install another PHP-Based MySQL program.
tbonekkt
10-19-06, 06:15 PM
It's not going to happen. I can say that with 99.9% certainty.
HalfaBee
10-19-06, 07:57 PM
I don't like PHPmyAdmin. :'(


I agree!
kanwulf
10-20-06, 01:14 AM
I went through this back when they first took remote connections away. :(


Clearly, I didn't get anywhere...
YvetteKuhns
10-20-06, 11:59 AM
Remote connections are a security risk. One of my clients has a website hosted elsewhere that does allow remote connections. His shopping cart was hacked and his newsletter email listing was stolen. (He had that system BEFORE he worked with me and he won't change it.)

Many hosts do not and will not allow such a security risk. Too bad people had to abuse the system and take away this option.
jmucchiello
10-20-06, 08:28 PM
Remote connections are a security risk. One of my clients has a website hosted elsewhere that does allow remote connections. His shopping cart was hacked and his newsletter email listing was stolen. (He had that system BEFORE he worked with me and he won't change it.)I don't disagree that remote connection are a security risk, but it sounds to me like the web application that ran his shopping cart was the security leak in this situation.
YvetteKuhns
10-20-06, 08:31 PM
The shopping cart was NOT open source and it was an Oracle database. But it WAS on a Windows server! :p