Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Sep 2010
    Posts
    124
    Thanks
    6
    Thanked 0 Times in 0 Posts

    how to give Ip address with port no as host IP

    i have ip address with port no like

    120.1.1.1:443

    when i use this ipwith port no as a hostIP Address in mysql it will not connecting

    so how do i do this


    plz help me

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,596
    Thanks
    80
    Thanked 4,633 Times in 4,595 Posts
    Depends on *HOW* you are trying to connect.

    Are you using PHP?

    Or just a command line interface to MySQL?

    Or what?

    With old style PHP mysql_connect, your method should work.

    With mysqli_connect, the port is specified separately.

    With command line, you would use something like
    Code:
    mysql -uUSER -pPASSWORD -h120.1.1.1 -P443
    So explain HOW you are trying to connect.

    NOTE: Since 443 is probably a secure port, you may need to specify the --ssl option as well.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    Regular Coder
    Join Date
    Sep 2010
    Posts
    124
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Old Pedant View Post
    Depends on *HOW* you are trying to connect.

    Are you using PHP?

    Or just a command line interface to MySQL?

    Or what?

    With old style PHP mysql_connect, your method should work.

    With mysqli_connect, the port is specified separately.

    With command line, you would use something like
    Code:
    mysql -uUSER -pPASSWORD -h120.1.1.1 -P443
    So explain HOW you are trying to connect.

    NOTE: Since 443 is probably a secure port, you may need to specify the --ssl option as well.

    hear i`m going to use third party software navicat..

    Ther in the navicat we have to give

    Hostname /IP ADDRESS
    Username
    password

    in there after giving ipaddress with port no it will give an error

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,596
    Thanks
    80
    Thanked 4,633 Times in 4,595 Posts
    http://www.navicat.com/manual/online...ual/index.html

    That pretty clearly says that PORT is a separate setting from host name/ip address.

    I don't use Navicat, but pretty clearly there *IS* a way to specify the port. Try playing around with "New Connection" and looking, for example, to see if there is an "options" button or property that you are missing.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

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