Just getting into database stuff a little bit, and wanted to double
check something with you guys.
I have a database, which has 2 tables, I have created a user using
this syntax: grant select, update, delete on dbname.table to
'me'@'localhost' identified by 'mypass';
then I also added access to another table: grant select on
dbname.othertable to 'me'@'localhost' identified by 'mypass';
the "other table" is used to store local accounts to a online
database, and my php script uses SELECT to check to see if they are
listed and if so grant them access. No one is accessing the database
directly except for me, and I would like to keep it that way.
Given the user that I created, is there anything else I need to worry
about? I only want local requests to be able to interface with the
database. I don't need Joe Blow for indiana to have direct access :)
Oh, and do I specifically have to disallow certain privileges if all
I want them to be able to do is delete, select or update records?
3251 132nd ave
Holland, MI, 49424
|• privileges||Jason Pruim||19 Sep|