{"metadata":{"image":[],"title":"","description":""},"api":{"url":"","auth":"required","results":{"codes":[]},"settings":"","params":[]},"next":{"description":"","pages":[]},"title":"[DATABASE]","type":"basic","slug":"database-db","excerpt":"Root user connection details and user names (and passwords) for database users to be created","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.","updates":[],"order":1,"isReference":false,"hidden":false,"sync_unique":"","link_url":"","link_external":false,"_id":"58c10f5a2c3c720f00768b9d","parentDoc":null,"createdAt":"2016-05-13T15:02:06.362Z","project":"5735936aafab441700723a50","__v":0,"version":{"version":"2.0","version_clean":"2.0.0","codename":"","is_stable":true,"is_beta":false,"is_hidden":false,"is_deprecated":false,"categories":["58c10f5a2c3c720f00768b88","58c10f5a2c3c720f00768b89","58c10f5a2c3c720f00768b8a","58c10f5a2c3c720f00768b8b","58c10f5a2c3c720f00768b8c","58c10f5a2c3c720f00768b8d","58c10f5a2c3c720f00768b8e","58c10f5a2c3c720f00768b8f","58c10f5a2c3c720f00768b90","58c10f5a2c3c720f00768b91","58c10f5a2c3c720f00768b92","58c10f5a2c3c720f00768b93","58c11574b36d8c0f006fda47","58c2cdcafc6eed3900e97640","58c2ce8afc6eed3900e97663"],"_id":"58c10f5a2c3c720f00768b87","project":"5735936aafab441700723a50","releaseDate":"2017-03-09T08:16:26.385Z","createdAt":"2017-03-09T08:16:26.385Z","__v":4},"githubsync":"","category":{"sync":{"isSync":false,"url":""},"pages":[],"title":"Configuration Options (Database)","slug":"configuration-options-database","order":11,"from_sync":false,"reference":false,"_id":"58c10f5a2c3c720f00768b90","project":"5735936aafab441700723a50","createdAt":"2016-05-13T14:33:40.982Z","__v":0,"version":"58c10f5a2c3c720f00768b87"},"user":"573592b84b0ab120000b7d44"}

[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.