Oracle 5.0, Reference Manual

Page: 2373 / 3232

MySQL Improved Extension (
Mysqli
)
2353
mysqli_commit
mysqli_rollback
20.7.3.9.3.
mysqli::change_user
,
mysqli_change_user
Copyright 1997-2012 the PHP Documentation Group. [2230]
•
mysqli::change_user
mysqli_change_user
Changes the user of the specified database connection
Description
Object oriented style
bool mysqli::change_user(
string user,
string password,
string database);
Procedural style
bool mysqli_change_user(
mysqli link,
string user,
string password,
string database);
Changes the user of the specified database connection and sets the current database.
In order to successfully change users a valid
username
and
password
parameters must be provided
and that user must have sufficient permissions to access the desired database. If for any reason
authorization fails, the current user authentication will remain.
Parameters
link
Procedural style only: A link identifier returned by
mysqli_connect
or
mysqli_init
user
The MySQL user name.
password
The MySQL password.
database
The database to change to.
If desired, the
NULL
value may be passed resulting in only changing
the user and not selecting a database. To select a database in this
case use the
mysqli_select_db
function.
Return Values
Returns
TRUE
on success or
FALSE
on failure.
Notes
Note
Using this command will always cause the current database connection to
behave as if was a completely new database connection, regardless of if the
operation was completed successfully. This reset includes performing a rollback
on any active transactions, closing all temporary tables, and unlocking all locked
tables.