I have MySQL db, I will write php scripts that will query db, but how do I grant permission to PHP scripts to query (SELECT, INSERT, DELETE) db, but no one else can be allowed to do so. PHP script is on localhost (the same machine or server)
I know about GRANT command in MySQL,
GRANT <privileges> ON <database> TO <user> [IDENTIFIED BY <password>
[b]HOW to edit <user> and INDENTIFIED BY commands to adapt them to php query (is thios done in the PHP or mysql [/b]