how to give Ip address with port no as host IP

[coolumanga]

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

[Old Pedant]

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

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.

[coolumanga]

Originally Posted by Old Pedant

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

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

[Old Pedant]

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.