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 ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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 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 ================== |
|
|||
|
..
> >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'? |
|
|||
|
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 ================== |
|
|||
|
>> >> ...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. |
|
|||
|
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 ================== |