Connecting to a MySQL Server in PHP
Q
How To Connect to MySQL from a PHP Script in PHP?
✍: FYIcenter.com
A
If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format:
$con = mysql_connect($server, $username, $password);
If you are connecting to a local MySQL server, you don't need to specify username and password. If you are connecting to a MySQL server offered by your Web hosting company, they will provide you the server name, username, and password.
The following script shows you how to connect to a local MySQL server, obtained server information, and closed the connection:
<?php
$con = mysql_connect('localhost');
print(mysql_get_server_info($con)."\n");
print(mysql_get_host_info($con)."\n");
mysql_close($con);
?>
If you run this script, you will get something like this:
5.0.2-alpha localhost via TCP/IP
2016-10-20, 470👍, 0💬