I am using MySQL on a single machine having Windows acting as localhost.
I added a new user administrator with password somepass
I logged on to MySQL with root and set the GRANT ALL ON *.* TO administrator identified by 'somepass';
But the grant_priv field in the user table is still 'N' so I updated it to 'Y'.
$dblink=mysql_connect("localhost","administrator","somepass") or die("Could not connect");
I don't understand what went wrong since I get this error : Warning: Access denied for user: 'administrator@localhost' (Using password: YES) in Register.php on line 11
If I simply do mysql_select_db("rac"); it works but I can only select query and not insert.
GRANT ALL PRIVILEGES ON *.* TO administrator@localhost IDENTIFIED BY 'somepass';
GRANT ALL PRIVILEGES ON *.* TO administrator@127.0.0.1 IDENTIFIED BY 'somepass';