How To Connect to a MySQL Sever with a Port Number

Q

How To Connect to a MySQL Sever with a Port Number? - MySQL FAQs - PHP Connections and Query Execution

✍: FYIcenter.com

A

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, 5595👍, 0💬

How To Get Some Basic Information Back from MySQL Servers
How To Get Some Basic Information Back from MySQL Servers? - MySQL FAQs - PHP Connections and Query Execution Once you got a MySQL server connection object successfully, you can use mysql_get_server() and mysql_get_host_info() to get some basic information from your MySQL server. The tutorial exerci... 2007-05-10, 5669👍, 0💬

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 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 exerci... 2007-05-10, 5596👍, 0💬

How To Connect to a MySQL Sever with Default Port Number
How To Connect to a MySQL Sever with Default Port Number? - MySQL FAQs - PHP Connections and Query Execution If you want to connect a MySQL server with default port number, you can use the "mysql_connect($server)" function, where $server is the host name or IP address where the MySQL server is runni... 2007-05-10, 5564👍, 0💬

How To Connect to MySQL Severs with User Accounts
How To Connect to MySQL Severs with User Accounts? - MySQL FAQs - PHP Connections and Query Execution If you want to connect a MySQL server with user account name and password, you need to call mysql_connect() with more parameters like this: $con = mysql_connect($server, $username, $password); If yo... 2007-05-10, 5450👍, 0💬

How To Turn on mysql Extension on the PHP Engine
How To Turn on mysql Extension on the PHP Engine? - MySQL FAQs - PHP Connections and Query Execution The "mysql" API extension is provided as "php_mysql.dll" for Windows system. Your PHP binary download package should have "php_mysql.dll" included. No need for another download. But you need to check... 2007-05-10, 5333👍, 0💬

How To Access MySQL Servers through Firewalls
How To Access MySQL Servers through Firewalls? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MyS... 2007-05-10, 5319👍, 0💬

How To Close MySQL Connection Objects
How To Close MySQL Connection Objects? - MySQL FAQs - PHP Connections and Query Execution MySQL connection objects created with mysql_connect() calls should be closed as soon as you have finished all of your database access needs by calling mysql_close($con) function. This will reduce the consumptio... 2007-05-10, 5200👍, 0💬

How To Check Your PHP Installation
How To Check Your PHP Installation? - MySQL FAQs - PHP Connections and Query Execution PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\... 2007-05-10, 4999👍, 0💬

What Do You Need to Connect PHP to MySQL
What Do You Need to Connect PHP to MySQL? - MySQL FAQs - PHP Connections and Query Execution If you want to access MySQL database server in your PHP script, you need to make sure that a MySQL API module (extension) is installed and turned on in your PHP engine. PHP 5 now supports two MySQL API exten... 2007-05-10, 4915👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.