{"_id":"58c10f5a2c3c720f00768b9d","parentDoc":null,"project":"5735936aafab441700723a50","__v":0,"version":{"_id":"58c10f5a2c3c720f00768b87","project":"5735936aafab441700723a50","__v":4,"createdAt":"2017-03-09T08:16:26.385Z","releaseDate":"2017-03-09T08:16:26.385Z","categories":["58c10f5a2c3c720f00768b88","58c10f5a2c3c720f00768b89","58c10f5a2c3c720f00768b8a","58c10f5a2c3c720f00768b8b","58c10f5a2c3c720f00768b8c","58c10f5a2c3c720f00768b8d","58c10f5a2c3c720f00768b8e","58c10f5a2c3c720f00768b8f","58c10f5a2c3c720f00768b90","58c10f5a2c3c720f00768b91","58c10f5a2c3c720f00768b92","58c10f5a2c3c720f00768b93","58c11574b36d8c0f006fda47","58c2cdcafc6eed3900e97640","58c2ce8afc6eed3900e97663"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"2.0.0","version":"2.0"},"githubsync":"","category":{"_id":"58c10f5a2c3c720f00768b90","project":"5735936aafab441700723a50","__v":0,"version":"58c10f5a2c3c720f00768b87","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-13T14:33:40.982Z","from_sync":false,"order":11,"slug":"configuration-options-database","title":"Configuration Options (Database)"},"user":"573592b84b0ab120000b7d44","updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-05-13T15:02:06.362Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":1,"body":"```\n[DATABASE]\n  DB_USER = anonymous\n  DB_PASS =\n\n  DB_SESSION_USER = ensrw\n  DB_SESSION_PASS = ensrw\n\n  DB_IMPORT_USER = importer\n  DB_IMPORT_PASSWORD = importpassword\n\n  DB_ROOT_USER = root\n  DB_ROOT_PASSWORD = secretpassword\n  DB_PORT = 3306\n  DB_HOST = localhost\n```\n- ``DB_USER`` has ``SELECT`` permissions only and will be used as the 'ro' user for the Ensembl instance. \n- ``DB_SESSION_USER`` has permissions on the ``ensembl_accounts`` database and will be used as the 'rw' user for the Ensembl instance.  \n- ``DB_IMPORT_USER`` has more extensive permissions on all databases and will be used during Core and Compara Import.","excerpt":"Root user connection details and user names (and passwords) for database users to be created","slug":"database-db","type":"basic","title":"[DATABASE]"}

[DATABASE]

Root user connection details and user names (and passwords) for database users to be created

``` [DATABASE] DB_USER = anonymous DB_PASS = DB_SESSION_USER = ensrw DB_SESSION_PASS = ensrw DB_IMPORT_USER = importer DB_IMPORT_PASSWORD = importpassword DB_ROOT_USER = root DB_ROOT_PASSWORD = secretpassword DB_PORT = 3306 DB_HOST = localhost ``` - ``DB_USER`` has ``SELECT`` permissions only and will be used as the 'ro' user for the Ensembl instance. - ``DB_SESSION_USER`` has permissions on the ``ensembl_accounts`` database and will be used as the 'rw' user for the Ensembl instance. - ``DB_IMPORT_USER`` has more extensive permissions on all databases and will be used during Core and Compara Import.