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.
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.
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!!!