HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free and registered users see less advertising! If you just want to browse through the existing questions, just select the forum that you want to visit from the selection below. Otherwise, click here to register!. We highly recommend that you print a copy of our Guide for New Members. Enjoy!

Mysql command line on network

Hi,
In our database lab, there is server running windows 2000 and several clients connected to it (all win 2000), MySQL server is installed on the server, and MySQL Administrator on all clients. I can access the MySQL server through the network using MySQL Administrator, but I have no idea how should I connect to the MySQL server from command line.
On my pc at home, it is very easy, just out the mysql in the PATH enviroment variable and its done.
Can anyone help me how should I connect to the server from command line through a network?
Thnaks in advance.

It has section [client] that is common for all mySQL programs and then separate section for each program.

You can supply all these parameters on command line too. In your case you probably need host. It's DNS name of the server or IP address. And may be you need to specify port too, if it uses some non standard port. But this I am not sure how. May be just to add something like :1234 to address.

And, BTW, if they don't have mySQL port firewalled, you can access it from any place on the Internet. At least my server provider has it open, and I can use mySQL from my home machine.

Hi,
In our database lab, there is server running windows 2000 and several clients connected to it (all win 2000), MySQL server is installed on the server, and MySQL Administrator on all clients. I can access the MySQL server through the network using MySQL Administrator, but I have no idea how should I connect to the MySQL server from command line.
On my pc at home, it is very easy, just out the mysql in the PATH enviroment variable and its done.
Can anyone help me how should I connect to the server from command line through a network?
Thnaks in advance.