Connect to MySQL DatabaseShortcuts • • Home RSS feed for page Tags • Authentication Date DateTime • • • • • • • Getting Started MySQL Installation PHP PHP Installation Validation View more Table of Contents • • • • • • • • • • • • • • • Getting Started with MySQL Connect to MySQL Database Create a MySQL Database With PHP Insert Data into a MySQL Database Retrieve Data From a MySQL Database MySQL Update and Delete Using PHP to Backup MySQL Databases Uploading Files To MySQL Database Content Management System ( CMS ) using PHP and MySQL User Authentication : Storing User ID's and Passwords In a MySQL Database Starting MySQL Add New MySQL User Create New MySQL Database Create a Table in MySQL Add Data to a MySQL Database • • Retrieve Data from MySQL Table Update and Delete in MySQL Page Details Published by: admin on 12-18-2008 10 people found this article useful. Article Comments (16) 100% of people found this useful Connect to MySQL Database value: [Edit Tags] Opening a connection to MySQL database from PHP is easy. Just use the mysql_connect() function like this <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die mysql'); $dbname = 'petstore'; mysql_select_db($dbname); ?> $dbhost is the name of MySQL server. When your webserver is on the same machine with the MySQL server you can use localhost or 127.0.0.1 as the value of $dbhost. The $dbuser and $dbpass are valid MySQL user name and password. For adding a user to MySQL visit this page : MySQL Tutorial Don't forget to select a database using mysql_select_db() after connecting to mysql. If no database selected your query to select or update a table will not work. ('Error connecting to Sometimes a web host will require you to specify the MySQL server name and port number. For example if the MySQL server name is db.php-mysql-tutorial.com and the port number is 3306 (the default port number for MySQL) then you you can modify the above code to : <?php $dbhost = 'db.php-mysql-tutorial.com:3306'; $dbuser = 'root'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die $dbname = 'petstore'; mysql_select_db($dbname); ?> It's a common practice to place the routine of opening a database connection in a separate file. Then everytime you want to open a connection just include the file. Usually the host, user, password and database name are also separated in a configuration file. An example of config.php that stores the connection configuration and opendb.php that opens the connection are : Source code : config.phps , opendb.phps <?php // This is an example of config.php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password'; $dbname = 'phpcake'; ?> <?php // This is an example opendb.php $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die mysql_select_db($dbname); ?> So now you can open a connection to mysql like this : <?php include 'config.php'; include 'opendb.php'; // ... do something like insert or select, etc ?> ('Error connecting to mysql'); ('Error connecting to mysql'); Closing the Connection The connection opened in a script will be closed as soon as the execution of the script ends. But it's better if you close it explicitly by calling mysql_close() function. You could also put this function call in a file named closedb.php. Source code : closedb.phps <?php // an example of closedb.php // it does nothing but closing // a mysql database connection mysql_close($conn); ?> Now that you have put the database configuration, opening and closing routines in separate files your PHP script that uses mysql would look something like this : <?php include 'config.php'; include 'opendb.php'; // ... do something like insert or select, etc include 'closedb.php'; ?> Recent Comments By: phpmsqltutor Posted on 12-02-2009 10:29 PM The IP address. e.g. 192.168.1.5:3306 If you don't know, 3306 is the default mysql port. By: Bright-Tutorials Posted on 12-21-2009 8:42 PM Real awesome tutorial, between this one and the one at http://bright-tutorials.com I was able to understand some basic php code! By: Bright-Tutorials Posted on 12-21-2009 9:21 PM Great tutorial. I really appreciate it. This tutorial and the ones over at http://bright-tutorials.com really helped me with php and mysql. Thanks! By: zeroge Posted on 01-01-2010 4:45 AM Great tutorial and great idea ... just in my way I get an error Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'me'@'here' (using password: NO) in /home/bla/bal/balla/opendb.php on line 3 Unable to select database Where "balla" is the password protected directory. Trying to open the directory itself by typing simply the URL like htt://mydomain.com/balla/ I will be prompted for providing a username and password, though the directory seems to work. Why is it I get then this error when trying to call the page that hosts the "includes" ? Thanks a lot By: Ivan Posted on 05-13-2010 5:12 AM I'm new to PHP, hope someone can give me a hand : ) I can't connect to MySQL, IE prompted me "HTTP 500" can't display the web page. By following the instructions from a PHP-MySQL book, I did the followings: I installed Apache 2.2.15, PHP 5.3.2, MySQL 5.1.45. Created directory c:\Program Files\PHP\extensions, and have libmysql.dll and php_mysqli.dll saved inside. In c:\windows\system32, libmysql.dll was included. In c:\Program Files\PHP\php.ini, two lines were included: extension_dir = “c:\Program Files\PHP\extensions extension=php_mysqli.dll my connection.php file saved in c:\Program Files\Apache Software Foundation\Apache2.2\htdocs, and called from localhost/connection.php Any things else I still missed? thanks all. View All Alone