Unanswered: how to connect to database(in diff. machine) using mysqlcc
Just started using "mysql" as our database. The operating system is win 2000, mysql version 4.0.16 and mysql control centre 0.93 beta.I have two mysql databases in two different machine (Development & local workstation). Using mysql cc i want to montior the development database.
Is there anything like "listener" and "tnsnames" configuration in oracle
Any services need to be started inorder acces from other machine?
Any configuration need to be done in the local workstation.
When mysql starts it automatically listens to
(default) port 3306. You can test this by telneting
to port 3306: telnet <machine_name> 3306.
You wont see a lot, except the server version,
but it proves that MySQL is accessible via TCP/IP.
So, no, you do not need to manually start up
Oracle's listener program (or anything like it)
to acess MySQL from a remote machine.
You can find out which port your version of MySQL
is listening to by going to (default) directory
c:\mysql\data and grep the <machine_name>.err
file for "port:".
Re: how to connect to database(in diff. machine) using mysqlcc
Originally posted by D.Ramesh
In the .err file i am able to see the port (3306) in which mysql is listening. How to connect from my machine to the server.....?
Well, you don't say which program you are connecting
to MySQL, so I'll assume it's mysql, which is similar to
isql and osql.
It's very simple. At the DOS command line you start
mysql up with:
mysql -u <username> -p --host=<host_IP_address> <database name>
Your working directory should probably be mysql/bin when
you try this for the first time. (Ignore the greater-than and
less-than signs in the command line above--they are there
to indicate that you need to insert your own username,
host name, and database name in place of those variables.