Hello there, I have a question for the mysql cracks out there;

Assuming I have a website set up with a mysql database, is there a way I can log into my database from a distant computer and work with it remotely just by knowing the web or ip address and obviously, my user name and password?

Looks like it's going to get tougher than that...

Here's another question; I was hosting my website with eHostPros a while back, and the address to access the control panel was https://kilgayne.net:2083/. I understand the s of https stands for secure, but what about the "port number", the 2083 next to the address? Is it a port assigned by my host to redirect to the control panel? Is there anything like this made by default when you make your own server or rent a hosting plan with an external company?

Please respond to this, I really need to know.

Still no idea?... I thought people on a web development forum would know =/

re: https
How your site is accessed is determined by the hosting service.
You should contact them about these questions.
If it is YOUR server you will need to contact yourself as you will be the one who sets all these things up!
Look for tutorials on this.
I recently did an HP learning center 'Linux 401' thing which went through a lot of the basics.
Thry probably have something similar for MS server setup...

re: manipulating mysql
Remote access?
Usually you will use ftp to place html or php files for this.
You could also type and edit them right in place through ssh or telnet access.
There are also some gui apps that a hoster might have available.
See if this gives you some ideas:
http://www.tizag.com/mysqlTutorial/index.php

Sorry I missed this question, Kilgayne. I was not online at the time you posted this thread.

It is quite simple to access your MySQL server from anywhere if you set it up to allow remote connections. In your MySQL server, set up a user (of course) and set up the hostname (or you could even supply an IP address, if I am not mistaken) that you will be connecting from and assign the proper permissions. That's all! Don't forget to flush privileges before you attempt to connect to the server.

I am sorry if this information is too late but it may help someone else reading this thread in the future.

__________________
Custom BB codes you can use here:
[HTML] | [C++] | [CSS] | [JAVA] | [PY] | [VB]