Collections:
Connect to MySQL Server with Port Number in MySQL
How To Connect to a MySQL Server with a Port Number in MySQL?
✍: 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.
⇒ Connect to MySQL Server with User Account in MySQL
⇐ Connect to MySQL Server without Port Number in MySQL
2017-11-25, 1557🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...