 |
|
 PhpDig.net |
What is PhpDig?
PhpDig is a PHP MySQL based Web Spider & Search Engine. |
mysql_change_user
Synopsis
bool mysql_change_user(user, password[, database][, connection]);
string user: Username to log
in with
string password: Password to
use
string database (optional):
Default database to use for queries
mysql link connection
(optional): Connection handle returned by mysql_connect() or mysql_pconnect()
Description
mysql_change_user() allows the user for any active MySQL connection to be changed as desired.
The user and password arguments are required. The optional database argument is used to set the default database to use with calls to mysql_query() for the MySQL connection given in connection . If no connection handle is specified in the connection argument, the last connection opened is used by default.
Example
Example 787. Connect to a database and change the active user for the connection
<?php
// Connect to the default MySQL server
$mysql_link = mysql_connect ()
or die ("Could not connect to the default MySQL server.");
$user = 'bill';
// Attempt to change the user on the MySQL connection
if (mysql_change_user ($user, 'chupachups')) {
echo "User changed to <b>$user</b>.";
} else {
echo "User could not be changed to <b>$user</b>.";
}
?>