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, 5021👍, 0💬
Popular Posts:
If we inherit a class do the private variables also get inherited ? Yes, the variables are inherited...
How to convert a Unix timestamp to a Win32 FILETIME or SYSTEMTIME? The following function converts a...
Where are cookies actually stored on the hard disk? This depends on the user's browser and OS. In th...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
If XML does not have closing tag will it work? No, every tag in XML which is opened should have a cl...