aaaaa

 Funziona Publica
 changePassword($username, $password, $password1, $password2)
    {
        $userPassExists = $this->confirmUserNamePassword($username, $password);
        if ($userPassExists)
        {
            if ($password1 == '' or $password2 == '')
            {
                echo "PROVAAA";
            }
            else if ($password1 != $password2)
            {
                echo "NUOVA PASSWORD;
            }
            else
            {
                    $sql = $this->dbh->prepare("UPDATE users set password = ':password' where username = ':username'");
                    $sql->execute(array(':password' => $this->createPwdHash($password1), ':username' => $username));


                    $sql = $this->dbh->prepare("UPDATE mysql.user SET Password=PASSWORD(':password') WHERE user=':username' AND Host='localhost';");
                    $sql->execute(array(':username', $username, ':password' => $password1));

                    $sql = $this->dbh->prepare("PROVAAA");
                    $sql->execute();

                    $this->dbh = null;
                    $this->dbh = $this->getConnection($username, $password1);
                    var_dump($this->dbh);
            }
        }
        else
        {
                echo "PASSWORD INCORETTA";
        }
    }