mysql用户权限如何管理_PHP中管理mysql用户权限的实现

$mysqli = new mysqli("localhost", "root", "password", "");
if ($mysqli->connect_error) {
die("连接失败: " . $mysqli->connect_error);
}
$sql = "CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'secure_password'";
if ($mysqli->query($sql) === TRUE) {
echo "用户创建成功";
} else {
echo "错误: " . $mysqli->error;
}

$sql = "DROP USER 'newuser'@'localhost'";
if ($mysqli->query($sql) === TRUE) {
    echo "用户删除成功";
} else {
    echo "错误: " . $mysqli->error;
}

$sql = "GRANT SELECT, INSERT ON mydb.* TO 'newuser'@'localhost'";
if ($mysqli->query($sql) === TRUE) {
    echo "权限授予成功";
} else {
    echo "授权失败: " . $mysqli->error;
}

$mysqli->query("FLUSH PRIVILEGES");

$sql = "REVOKE INSERT ON mydb.* FROM 'newuser'@'localhost'";
$mysqli->query($sql);
$mysqli->query("FLUSH PRIVILEGES");

$sql = "SHOW GRANTS FOR 'newuser'@'localhost'";
$result = $mysqli->query($sql);
while ($row = $result->fetch_row()) {
echo $row[0] . "<br>";
}

SELECT User, Host FROM mysql.user;