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

This is a discussion on How do connect a Windows box called 'winbox' using mysql.exe within the MySQL Database forums, part of the Database Forums category; I'm trying to connect to a box running WinXP and mysql 5 called 'winbox' from another Windows box running ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-12-2007
Pete
 
Posts: n/a
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.
Reply With Quote
  #2 (permalink)  
Old 03-12-2007
Jerry Stuckle
 
Posts: n/a
Default Re: How do connect a Windows box called 'winbox' using mysql.exe

Pete wrote:
> 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.


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.
jstucklex@attglobal.net
==================
Reply With Quote
  #3 (permalink)  
Old 03-13-2007
Pete
 
Posts: n/a
Default Re: How do connect a Windows box called 'winbox' using mysql.exe

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


....And so what do I use if the host name is 'winbox'?
Reply With Quote
  #4 (permalink)  
Old 03-13-2007
Jerry Stuckle
 
Posts: n/a
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.

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


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.
jstucklex@attglobal.net
==================
Reply With Quote
  #5 (permalink)  
Old 03-15-2007
Pete
 
Posts: n/a
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'?

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


That's the name that pops up in the 'host name' field when I type
'ipconfig /all' in WinXP. Thanks.
Reply With Quote
  #6 (permalink)  
Old 03-15-2007
Jerry Stuckle
 
Posts: n/a
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'?

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

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


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.
jstucklex@attglobal.net
==================
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:24 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0