PHP mysqli change_user() 函数

示例 - 面向对象风格

更改指定数据库连接的用户：

<?php
$mysqli = new mysqli("localhost","my_user","my_password","my_db");

if ($mysqli -> connect_errno) {
echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
exit();
}

// Reset all and select a new database
$mysqli -> change_user("my_user", "my_password", "test");

$mysqli -> close();
?>

查看底部的程序样式示例。

定义和用法

change_user() / mysqli_change_user() 函数更改指定数据库连接的用户，并设置当前数据库。

语法

面向对象风格：

$mysqli -> change_user( username, password, dbname)

程序风格：

mysqli_change_user( connection, username, password, dbname)

参数值

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

技术细节

返回值：	成功则为真。失败时为 FALSE
PHP 版本：	5+

示例 - 程序风格

更改指定数据库连接的用户：

<?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();
exit();
}

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

mysqli_close($con);
?>

❮ PHP MySQLi 参考