Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Unanswered: how to connect to database(in diff. machine) using mysqlcc

    Hi !
    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.

    Many Thanks!
    Ramesh

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    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:".

  3. #3
    Join Date
    Sep 2003
    Posts
    12

    how to connect to database(in diff. machine) using mysqlcc

    Hi!
    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.....?

    Many Thanks!
    Ramesh

  4. #4
    Join Date
    Nov 2003
    Posts
    91

    Re: how to connect to database(in diff. machine) using mysqlcc

    Originally posted by D.Ramesh
    Hi!
    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.....?

    Many Thanks!
    Ramesh
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •