How to access a MySQL database remotely?

Question

I have a MySQL database (MySQL Server 5.0) in my server.

Usually I use the command prompt to access a table of information stored in the database.

Can I know how I can access the server(i.e. the MySQL database) remotely using my laptop?

Do i need to install MySQL Server 5.0 in my laptop also? Please kindly explain the procedure.

thanks :)

Answer 1

There's a bunch of different methods.  You can use Telnet but if you opt for that type of remote login method then SSH might be a better choice.  SSH is regarded as more secure than Telnet.  For either method to work then there needs to be a server (Telnet or SSH) running on the machine with MySQL.  With this method you do not need to have MySQL installed on your laptop, just a Telnet or SSH client.

I use SSH to remotely manage my local network server.  I use Putty (also works for telnet) in Windows to connect to my Linux based server via SSH.    When you start Putty it will ask for the IP address or host name of the remote machine and port number to connect on.  Fill in that information and click "Open".  This will open a remote connection to that machine and ask for your login information.  Enter your username and password when prompted and then it will bring you to the shell.  Now you can access MySQL the same way you would if you were sitting at the server.

Answer 2

mysql -uusername -ppassword -hhostrname.domain.com dbname

You will need a MySQL installation for this command line to work.  If you're running Linux on your laptop, that should be easy enough to install.  For Windows, you'll probably need WampServer2..

Answer 3

All you need is a mysql client application.

Mysql has an app for this called mysql query browser.

You just have to set the username, password and domain on your remote server.