I am trying to maintain a MySQL db which is required for business usage. I recently ran into a problem where one of our programs would blow up with an SQL error; taking a look at the error message, the program description, and the database in question reveals that the program is trying to update some rows of the table without having the correct privileges for the user/password identification required to run the program.
I have looked at the only MySQL text I currently have on hand. It mentions the grant and revoke statements, but from what I can tell, 'grant' creates a new user. I need to change the permissions on an old user, and what little I've been able to find on the topic does not indicate how this would be done. Does anyone have any suggestions to offer?
Thank you for your consideration.