Database Setup
(added some information about the two user accounts needed during setup) |
|||
| Line 1: | Line 1: | ||
| − | == MySQL == | + | == Database users == |
| + | OpenCms does not create it's own database users. The installation of opencms ask for a database user with administration privileges. | ||
| + | |||
| + | === Administration User === | ||
| + | That administration user account is only used for creating a new database and all needed tables inside of that database. After Setup, OpenCms will not keep any information about this user account and will not use this user account again. | ||
| + | |||
| + | === Production User === | ||
| + | For production access, OpenCms needs a database user. OpenCms also asks for that second user account during that setup. As the Administration user, this user must have been created before setup. OpenCms will store the user name and password of this user and will after setup continue to use it for connecting to the database. | ||
| + | |||
| + | The database user account that is used for production should have reduced privileges. It should not be able to access other databases, nor should it be allowed to create or delete any databases or tables. | ||
| + | |||
| + | |||
| + | == Additional Tips for MySQL == | ||
[http://www.opencms-forum.de/opencms-forum/viewthread?thread=1006 Files > 16MB Support] | [http://www.opencms-forum.de/opencms-forum/viewthread?thread=1006 Files > 16MB Support] | ||
Revision as of 18:35, 6 November 2006
Contents |
Database users
OpenCms does not create it's own database users. The installation of opencms ask for a database user with administration privileges.
Administration User
That administration user account is only used for creating a new database and all needed tables inside of that database. After Setup, OpenCms will not keep any information about this user account and will not use this user account again.
Production User
For production access, OpenCms needs a database user. OpenCms also asks for that second user account during that setup. As the Administration user, this user must have been created before setup. OpenCms will store the user name and password of this user and will after setup continue to use it for connecting to the database.
The database user account that is used for production should have reduced privileges. It should not be able to access other databases, nor should it be allowed to create or delete any databases or tables.
