MYSQL TUTORIALS - MySQL Connection

MySQL Connection

Syntax:

Parameter	Description
server	Optional - The host name running database server. If not specified, then default value is localhost:3036.
user	Optional - The username accessing the database. If not specified, then default is the name of the user that owns the server process.
passwd	Optional - The password of the user accessing the database. If not specified, then default is an empty password.
new_link	Optional - If a second call is made to mysql_connect() with the same arguments, no new connection will be established; instead, the identifier of the already opened connection will be returned.
client_flags	Optional - A combination of the following constants: MYSQL_CLIENT_SSL - Use SSL encryption MYSQL_CLIENT_COMPRESS - Use compression protocol MYSQL_CLIENT_IGNORE_SPACE - Allow space after function names MYSQL_CLIENT_INTERACTIVE - Allow interactive timeout seconds of inactivity before closing the connection

Example:

[root@host]# mysql -u root -p
Enter password:******

ADVERTISEMENTS



						
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2854760 to server version: 5.0.9

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

						
mysql> exit
Bye

						Syntax:

connection mysql_connect(server,user,passwd,new_link,client_flag);

						Syntax:

bool mysql_close ( resource $link_identifier );

						Example:

<html>
<head>
<title>Connecting MySQL Server</title>
</head>
<body>
<?php
   $dbhost = 'localhost:3036';
   $dbuser = 'guest';
   $dbpass = 'guest123';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   if(! $conn )
   {
     die('Could not connect: ' . mysql_error());
   }
   echo 'Connected successfully';
   mysql_close($conn);
?>
</body>
</html>