trying to change password,but dunno wat adjusmnts to make on my code
?php
session_start();
$dbhost = "localhost";
$dbname = "phplogin";
$dbuser = "root";
$dbpass = "";
$conn = mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname, $conn) or die(mysql_error());
@$username = $_POST['username'];
@$password = $_POST['password'];
mysql_query("UPDATE mysql.user SET Password = PASSWORD('$password') WHERE User='$username'");
echo("Password changed.");
?> <fieldset><h1><b>Change Or Reset Your Password!!<b></h1>
<form action='change2.php' method='POST'>
<table><label><tr>
<td>Old password:</td> </label><td><input type='text' name='oldpassword'></td></tr>
<label><tr><td>New password:</td> </label><td><input type='password' name='newpassword'></td></tr>
<label><tr><td>Repeat New password: </label><input type='password' name='repeatnewpassword'></td></tr>
<tr><td><input type='submit' name='submit' value='change password'></td></tr></table>
</form></fieldset>