Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Connect to MySQL Server without Port Number

By: FYIcenter.com

(Continued from previous topic...)

How To Connect to a MySQL Server with Default Port Number?

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 running. If successful, mysql_connect() will return a connection object for you to allow you to run other MySQL API functions.

The tutorial exercise below shows you a simple connection call to a MySQL server on the "localhost":

<?php
  $con = mysql_connect('localhost');
  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, if your server is running a non-default port number, 3306. In that case, It will give this output:

PHP Warning:  mysql_connect(): Can't connect to MySQL server
   on 'localhost' (10061) in fyi_center.php on line 2
There is a problem with the MySQL connection.

(Continued on next topic...)

1. How To Install PHP on Windows?
2. How To Verify Your PHP Installation?
3. What Do You Need to Connect PHP to MySQL?
4. How To Turn on mysql Extension on the PHP Engine?
5. How To Connect to a MySQL Server with Default Port Number?
6. How To Connect to a MySQL Server with a Port Number?
7. How To Connect to MySQL Server with User Accounts?
8. How To Access MySQL Servers through Firewalls?
9. How To Get Some Basic Information Back from MySQL Servers?
10. How To Close MySQL Connection Objects?
11. How To Get a List of Databases from MySQL Servers?
12. How To Create a New Database?
13. What Happens If You Do Not Have Privileges to Create Database?
14. How To Get MySQL Statement Execution Errors?
15. How To Drop an Existing Database?
16. How To Select an Exiting Database?
17. Can You Select Someone Else Database?
18. How To Execute a SQL Statement?