Hi
When I set up OpenFAQ I set it up to use root user in MySQL. I was thinking for security reasons it may be a good idea to create a new user and set it up to run under this user. Would this be the way to go? If so then what permissions would this user need and would these permissions only have to apply to the OpenFAQ database?
Thanks
Greg
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2004-02-03
Hi Greg
Open FAQ ver 0.1.0 only support one user.
Since the Admin and Public section uses the same config file.
That means the user you create for the Open FAQ page need write access to the Database it uses.
For example: create a new database named ofaq, and in there you create the two tabels ofaq_qa and ofaq_configs.
Now you need to create a user that have write access to the ofaq Database.
In the "config.php" in the Open FAQ root dir, there is variables you can change to match the database and username/pass.
I think in future releases we will make the publick section and the admin section have different useracces to database, but we are still planing this...
Jan Stle
Programmer Open FAQ
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
When I set up OpenFAQ I set it up to use root user in MySQL. I was thinking for security reasons it may be a good idea to create a new user and set it up to run under this user. Would this be the way to go? If so then what permissions would this user need and would these permissions only have to apply to the OpenFAQ database?
Thanks
Greg
Hi Greg
Open FAQ ver 0.1.0 only support one user.
Since the Admin and Public section uses the same config file.
That means the user you create for the Open FAQ page need write access to the Database it uses.
For example: create a new database named ofaq, and in there you create the two tabels ofaq_qa and ofaq_configs.
Now you need to create a user that have write access to the ofaq Database.
In the "config.php" in the Open FAQ root dir, there is variables you can change to match the database and username/pass.
I think in future releases we will make the publick section and the admin section have different useracces to database, but we are still planing this...
Jan Stle
Programmer Open FAQ