如何更改mysql用户密码 - How to change mysql user password?

How to change mysql user password?

本文关键字：密码用户 mysql 何更改 | 更新日期: 2023-09-27

嗨，我正在使用以下脚本更改mysql用户密码，但密码没有更改。

$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);          
}

使用此脚本密码不会更改，也不会显示错误。

试试这个，这也有助于sql注入。

$query = sprintf("UPDATE mysql.user SET Password = '%s' WHERE User='%s'",mysqli_real_escape_string($dbPass),mysql_real_escape_string($dbUser));
$result = mysqli_query($query);
if($result){
   echo "change success";
}

尝试此查询可能会对您的有所帮助

mysql_query("UPDATE mysql.user SET Password = PASSWORD('$password') WHERE User='$username'");

只需尝试此查询

SET PASSWORD FOR 'bob'@'%.example.org' = PASSWORD('cleartext password');