Hi
I am developing a tool based on PHP/mySQL open to everyone, which means if a user wants to use it, he can create an account for himself (just like a Web-Email).
So what I need is a mySQL-User, who can create new users but only for a specific table.
Or in other words, I want a mySQL-user who is allowed to execute this query (and if possible THIS query only):
GRANT INSERT, UPDATE ON database.table TO new_user@localhost IDENTIFIED BY "password";
What has to be done? What about security?
cheers mates!
I am developing a tool based on PHP/mySQL open to everyone, which means if a user wants to use it, he can create an account for himself (just like a Web-Email).
So what I need is a mySQL-User, who can create new users but only for a specific table.
Or in other words, I want a mySQL-user who is allowed to execute this query (and if possible THIS query only):
GRANT INSERT, UPDATE ON database.table TO new_user@localhost IDENTIFIED BY "password";
What has to be done? What about security?
cheers mates!