Hi,
I'm having trouble giving my mysql users access. I have a user (npoole) who has the ability to read the db structure out of MyAdmin, but the user is not able to make new db's, or update previously existing ones. I've read the MySQL docs about user privledges, but I can't seem to find anything about editing already existing users. Any help would be appreciated.
-- Nathan
The command that you are looking for is called GRANT.
It's used like this:
grant update, insert, select, delete on table to user@host;
If your user doens't have a host listed in his record then you can leave the @host off of the end.
