I'm trying to connect to a MySQL database remotely using the mysql tool. The server resides on a box running W2K. At the remote site I'm on a windows box using the mysql.exe tool. I can't connect, but don't know if it's because I don't have the port open on the server or if I need to specify the port in my shell string.
1. On the server, how do I tell which port MySQL is listening on?
2. Can I (and if so, how do I) specify a port to connect to? I'm currently using > mysql -hxxx.xxx.xxx.xxx -uusername -p dbname
Thanks for any help.