Grant all to username - for inserting data
Posted: Fri Jan 02, 2004 12:50 pm
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'.
This is what I have :
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.
Thanks
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'.
This is what I have :
Code: Select all
$dblink=mysql_connect("localhost","administrator","somepass") or die("Could not connect");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.
Thanks