Mysql server port number

Question

I' have created a database on the MySQL on my server. I need to connect to this via my website using PHP. This is the data of my connections file:

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass)
    or die('Error connecting to mysql');

$dbname = 'epub';
mysql_select_db($dbname);

I know what is the username and passwords are, and I know the IP address of the server also. What I'm simply wondering is how do I know which port I should use?

Answer 1

If your MySQL server runs on default settings, you don't have to specify that.

The default MySQL port is 3306.

[updated to show mysql_error() usage]

$conn = mysql_connect($dbhost, $dbuser, $dbpass)
    or die('Error connecting to mysql: '.mysql_error());

Join the SQL Course by Intellipaat fast, to Learn SQL concepts in detail and get certified.