How can PHP be used to create and manage MySQL users and passwords?

To create and manage MySQL users and passwords using PHP, you can utilize MySQL queries to interact with the database. You can create a new user by running a query like "CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';" and grant permissions using "GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';". To update a user's password, you can use "SET PASSWORD FOR 'username'@'localhost' = PASSWORD('new_password');". 

<?php
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Create a new user
$sql = "CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'";
$conn->query($sql);

// Grant permissions to the new user
$sql = "GRANT ALL PRIVILEGES ON myDB.* TO 'newuser'@'localhost'";
$conn->query($sql);

// Update user's password
$sql = "SET PASSWORD FOR 'newuser'@'localhost' = PASSWORD('new_password')";
$conn->query($sql);

$conn->close();
?>

Keywords

PHP MySQL user management password management security

Related Questions