{"_id":"5735ec6ececa3f1700cc0535","version":{"_id":"5735936aafab441700723a53","__v":12,"project":"5735936aafab441700723a50","createdAt":"2016-05-13T08:42:18.615Z","releaseDate":"2016-05-13T08:42:18.615Z","categories":["5735936aafab441700723a54","5735a32931a73b1700887c94","5735b55beceb872200abbc6c","5735b56eb667601700d3bd6f","5735b9ba4b0ab120000b7dd4","5735b9c94b0ab120000b7dd5","5735cb131f16241700c8a0f7","5735e5c4e4824c3400aa1f21","5735e5d9e4824c3400aa1f23","5735e5f2ec67f6290013ac72","573ecfe0804f901700a9dfc7","573f276c7eeb8b190094ca7d"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":false,"codename":"","version_clean":"1.0.0","version":"1.0"},"parentDoc":null,"project":"5735936aafab441700723a50","__v":1,"category":{"_id":"5735e5c4e4824c3400aa1f21","project":"5735936aafab441700723a50","version":"5735936aafab441700723a53","__v":0,"sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-13T14:33:40.982Z","from_sync":false,"order":8,"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":"","githubsync":"","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.