When I execute my php script with this sql code:
$key = "aaaabbbbccccddddeeeeffffgggghhhh";
$con = mysql_connect($sql_host, $sql_user, $sql_pass) or die ('Error connecting to mysql'.mysql_error());;
mysql_select_db($sql_db, $con) or die("Could not select $sql_db");
// To work in "utf-8":
$query = "set names 'utf8'";
$result = mysql_query($query);
// Query:
$query = "UPDATE personaldata SET Key='".$key."' WHERE Id='".$Id."'";
mysql_query($query) or die(mysql_error());
mysql_close($con);
I obtain this error:
SELECT command denied to user 'userwrite'@'localhost' for column 'Id' in table 'personaldata'
But I am not using the "SELECT" command but "UPDATE"!!! Does it has any sense?