All I want is to connect to my remote server

[utopian]

I have a hosting service through a third party and they have set up remote access to my MySQL database for me. I downloaded the program off of www.mysql.com and ran mysql.exe and got a prompt. I then try to connect, but it won't let me. The prompt already looks like this: mysql>

Then I type -h hostname -u username -p

and it doesn't work. It says can't connect and results in an error. I can't figure out what I'm doing wrong. Any help would be greatly appreciated.

Thank you,
Utopian
mattharper8@hotmail.com

[atomicmunky]

some hosts do not allow remote connections for security reasons.

have you tried telnet-ing to your site and *then* connecting to mysql?

[seanf]

mysql.exe is the actually MySQL program. You need a DB management program, such as MySQL Front

Sean

[utopian]

Well, I installed MySQL Front and got connected to my database, but I still don't see where I can just use a prompt. MySQL Front is more of a GUI and I just want a prompt. This still helps me out a little though and thank you for your help.

I can't telnet either. I have remote access, but I can't telnet and then run the MySQL client off their machine. I think this is because my host has several users using MySQL on the same machine.

[seanf]

Sorry, I did not realise you were looking for a prompt. Your host offers you Telnet access, so you should be able to do it. Can you actually connect to your site through Telnet/SSH?

Sean

[utopian]

When I open telnet, I try typing in:
open www.domain.com 3306
it acts like it's connecting, then loses it.

If I type in:
open www.domain.com
it refuses my connection

I also tried:
mysql -h hostname -u username -p
and that didn't work either

I'm thinking that my host doesn't support remote access if you want a prompt because I think if I'm understanding this corrently, Telnet is really the only way to do that... Telnet to my domain and then open the MySQL program from there. Thanks for your help. SitePoint is addicting!!!