Professional Web Applications Themes

How do connect a Windows box called 'winbox' using mysql.exe - MySQL

I'm trying to connect to a box running WinXP and mysql 5 called 'winbox' from another Windows box running mysql.exe. The name of the latter box is 'winbox1'. The mysql server is up and running and I can ping the box. How do I connect as root? mysql -h (what_do_I_put_here?) -u root -p Should I be using //winbox , \winbox, ipaddress (I'm behind a firewall and the ipaddress is 198.168.1.120), //winbox/localhost...or something else? Thank you....

  1. #1

    Default How do connect a Windows box called 'winbox' using mysql.exe


    I'm trying to connect to a box running WinXP and mysql 5 called
    'winbox' from another Windows box running mysql.exe. The name of the
    latter box is 'winbox1'. The mysql server is up and running and I can
    ping the box. How do I connect as root?

    mysql -h (what_do_I_put_here?) -u root -p

    Should I be using //winbox , \\winbox, ipaddress (I'm behind a
    firewall and the ipaddress is 198.168.1.120), //winbox/localhost...or
    something else? Thank you.
    Pete Guest

  2. #2

    Default Re: How do connect a Windows box called 'winbox' using mysql.exe

    Pete wrote: 

    The ip address or the TCP/IP name (which would have to be resolved by a
    private DNS or your HOSTS file).

    //winbox, \\winbox, etc. are not TCP/IP host names.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: How do connect a Windows box called 'winbox' using mysql.exe

    .. 

    ....And so what do I use if the host name is 'winbox'?
    Pete Guest

  4. #4

    Default Re: How do connect a Windows box called 'winbox' using mysql.exe

    Pete wrote: 
    >
    > ...And so what do I use if the host name is 'winbox'?[/ref]

    Is that the TCP/IP name of the box, and do you have a DNS which will
    resolve that name (or have it in your HOSTS file)?

    TCP/IP is not the same as windows networking!

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  5. #5

    Default Re: How do connect a Windows box called 'winbox' using mysql.exe

     
    >
    >Is that the TCP/IP name of the box, and do you have a DNS which will
    >resolve that name (or have it in your HOSTS file)?
    >
    >TCP/IP is not the same as windows networking![/ref]

    That's the name that pops up in the 'host name' field when I type
    'ipconfig /all' in WinXP. Thanks.
    Pete Guest

  6. #6

    Default Re: How do connect a Windows box called 'winbox' using mysql.exe

    Pete wrote: 
    >> Is that the TCP/IP name of the box, and do you have a DNS which will
    >> resolve that name (or have it in your HOSTS file)?
    >>
    >> TCP/IP is not the same as windows networking![/ref]
    >
    > That's the name that pops up in the 'host name' field when I type
    > 'ipconfig /all' in WinXP. Thanks.[/ref]

    OK, that's the name of the box as it knows itself. But you still need a
    DNS to tell other hosts about it, or you need an entry in your HOSTS file.

    There is not 'I AM winbox' broadcast in TCP/IP. Everything is
    eventually handled by IP addresses, and somehow your other box needs to
    be able to relate 'winbox' to an IP address.

    And hopefully you don't have more than one 'winbox' on your TCP/UP
    network.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

Similar Threads

  1. Replies: 1
    Last Post: January 23rd, 12:06 PM
  2. Replies: 0
    Last Post: January 29th, 02:03 PM
  3. Replies: 7
    Last Post: June 12th, 07:43 AM
  4. Replies: 1
    Last Post: January 27th, 02:49 AM
  5. Replies: 0
    Last Post: January 24th, 10:55 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139