X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR BOOTSTRAP XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

PHP mysqli_change_user() Function

PHP MySQLi Reference 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($link, "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 PHP MySQLi Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates

SHARE THIS PAGE

facebook