CodingForums.com - View Single Post - how to give Ip address with port no as host IP

Old Pedant · 12-28-2012, 10:09 PM

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.

12-28-2012, 10:09 PM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,187 Thanks: 59 Thanked 3,995 Times in 3,964 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.