[SOLVED]GRANT to PHP script but to no one else IS IT POSSIBL
Posted: Sun Jan 25, 2004 3:03 am
Hello and greetings to all of those daring souls who entered this realm willingly>
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]
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]