How to grant privileges to a mysql user by using php?
Posted: Thu Nov 06, 2008 6:52 am
How to grant privileges to a mysql user by using php.
I work on a php project where I can
1: Create database by using php script.
2: Create user in mysql by using php script.
3: Grant access to user for the specific database by using php script.
Problem is in step no 3.
I need to know how can grant access to user for a specific database by using php script, where the user has full access control on has database but the other database should not accessible.
Need some privileges techniques overcome the above problem.
If any one have knowledge about the privileges then please help me!
Thank
Best regard
I work on a php project where I can
1: Create database by using php script.
2: Create user in mysql by using php script.
3: Grant access to user for the specific database by using php script.
Problem is in step no 3.
I need to know how can grant access to user for a specific database by using php script, where the user has full access control on has database but the other database should not accessible.
Need some privileges techniques overcome the above problem.
If any one have knowledge about the privileges then please help me!
Thank
Best regard