How to change mysql user password using php script?

Question

I am create user using bellow script

$conn = mysqli_connect('host', 'root', 'password');
$dbName = "userdb";
$dbUser = "username";
$dbPass = "password";

$queries = array(
        "CREATE DATABASE `$dbName` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci",
        "CREATE USER '$dbUser'@'localhost' IDENTIFIED BY '$dbPass'",
        "GRANT USAGE ON * . * TO '$dbUser'@'localhost' IDENTIFIED BY '$dbPass' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0",
        "GRANT CREATE, SELECT , INSERT , UPDATE, DELETE ON `$dbName` . * TO '$dbUser'@'localhost'",
        "GRANT ALL PRIVILEGES ON *.* TO '$dbUser'@'%' IDENTIFIED BY '$dbPass'",
        "FLUSH PRIVILEGES"
    );

    foreach($queries as $query) {
        $rs = mysqli_query($conn, $query);          
    }

Using this Script user create successfully .

How to change this user password in future using php script?

Tim Biegeleisen · Accepted Answer · 2015-03-11 06:57:25Z

3

You can use the following PHP script to change the password on your MySQL database:

$conn = mysqli_connect('host', 'root', 'password');
$dbUser = "username"; # same username as in your example
$dbPass = "new_password"; # new password

$queries = array(
  "USE mysql;", # switch to the 'mysql' database
  "SET PASSWORD FOR '$dbUser'@'localhost' = PASSWORD('$dbPass');"
);

foreach($queries as $query) {
    $rs = mysqli_query($conn, $query);          
}

Note that there is nothing magical happening here. We are changing the user password as you normally would from the MySQL prompt, except we are doing it from PHP instead.

answered Mar 11, 2015 at 6:57

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim Biegeleisen Over a year ago

@JayeshVekariya You need to replace the values in my example with those corresponding to your actual database setup.

Collectives™ on Stack Overflow

How to change mysql user password using php script?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related