sorry, forgot to mark this as solved, the users were set, the issue was the ownership of the files in the /var/lib/mysql (the mysql databases) that was set to a different user than mysql, not allowing UPDATE queries to be run due to lack of permissions (mysql could not write the changes). this caused the problem and its now solved: the solution (im my case) was to change (chown) the owner to mysql user.
Thanks anyway for the help firefly2000