Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Connect to a MySQL Sever with a Port Number
How To Connect to a MySQL Sever with a Port Number? - MySQL FAQs - PHP Connections and Query Execution
✍: FYIcenter.com
If you want to connect a MySQL server with a non-default port number, you need to use the "mysql_connect($server)" function with $server in the format of "hostName:portNubmber". The tutorial exercise below shows you how to connect to localhost at port number 8888:
<?php $con = mysql_connect('localhost:8888'); if (!$con) { print("There is a problem with MySQL connection.\n"); } else { print("The MySQL connection object is ready.\n"); mysql_close($con); } ?>
But this will not work, even you got the right port number, if your server requires user account authentication. In that case, It will give this output:
PHP Warning: mysql_connect(): Access denied for user 'ODBC'@'localhost' (using password: NO) in fyi_cener.php on line 2 There is a problem with the MySQL connection.
2007-05-10, 4971👍, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows? - Oracle DBA FAQ - Understanding SQL DML ...
Is XHTML Element Name Case Sensitive? - XHTML Tutorials - Introduction To Tag and Attribute Syntax Y...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
What are the five levels in CMMI? There are five levels of the CMM. According to the SEI, Level 1 – ...
What is the version information in XML? “version” tag shows which version of XML is used.