Latest web development tutorials
 

PHP mysqli_change_user() Function

< PHP MySQLi Reference

Example

Change the user of the specified database connection:

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

// Reset all and select a new database
mysqli_change_user($con, "my_user", "my_password", "my_test");

mysqli_close($con);
?>

Definition and Usage

The mysqli_change_user() function changes the user of the specified database connection, and sets the current database.


Syntax

mysqli_change_user(connection,username,password,dbname);

Parameter Description
connection Required. Specifies the MySQL connection to use
username Required. Specifies the MySQL username
password Required. Specifies the MySQL password
dbname Required. Specifies the database to change to

Technical Details

Return Value: TRUE on success. FALSE on failure
PHP Version: 5+

< PHP MySQLi Reference