I'm new to PHP and MySQL..
I get the following error when I do the "Flush Privileges" statement: Access denied; you need the RELOAD privilege for this operation
It actually does to the insert statement above - I don't know if I need the "Flush Privileges" or not, but it was part of the example, and it seems like clearing out the settings on the server was a good idea (if i understand what flushing does correctly)
I created a database using MySQL WorkBench - but i forgot to put an Auto_Increment on the primary key, so I had to add it later. After adding it, the error started coming up. I created a whole new table, just to see if it was related to the table, but it's doing it on the new table.
Thanks for your help!!!
$query = "INSERT INTO myTable (Name) VALUES ('Name')";
mysql_query($query) or die('Error, insert query failed - 1' . mysql_error());
//This is the error section...
$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, query failed - 2' . mysql_error());
echo "New MySQL user added";