### Author:  [@Hammad\_Abbasi](https://meta.discourse.org/u/Hammad_Abbasi)
#### Post date: [August 14, 2016, 2:24pm UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/1 "2016-08-14T14:24:25Z")
Hi,
I am running discourse multi-site setup, I am wondering how can i create administrator using
rake admin:create
It creates the administrator on first site.
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [August 14, 2016, 5:38pm UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/2 "2016-08-14T17:38:02Z")
You have to switch database using the `RAILS_DB=` prefix before the command
```plaintext
RAILS_DB=site1 rake admin:create
```
---
### Author:  [@Hammad\_Abbasi](https://meta.discourse.org/u/Hammad_Abbasi)
#### Post date: [August 19, 2016, 6:30am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/3 "2016-08-19T06:30:34Z")
It’s still creating admin account for first web site
---
### Author:  [@Hammad\_Abbasi](https://meta.discourse.org/u/Hammad_Abbasi)
#### Post date: [August 19, 2016, 6:50am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/4 "2016-08-19T06:50:28Z")
I am also trying to connect to 2nd database manually using
su -c ‘psql discourse’ postgres
but it throws error “no password entry for user postgres”
---
### Author:  [@Hammad\_Abbasi](https://meta.discourse.org/u/Hammad_Abbasi)
#### Post date: [August 19, 2016, 8:29am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/5 "2016-08-19T08:29:23Z")
Hi,
I have setup a multi-site up and running however I am unable to create admin or configure notification email for 2nd site
so i have few questions
How can i configure SiteSettings in app.yml for a) 2nd Site b) ALL SITES
- exec: rails r “SiteSetting.notification\_email=‘’”
I have tried manually connecting to both databases using
sudo -u postgres psql b\_discourse
but when i run select \* from users ( it returns nothing )
I tried running “rake admin:create RAILS\_DB=b\_discourse”- but this is creating the user on first site.
I ran “SiteSetting.notification\_email” command in rails console it shows email from 1st Site - is there any way i can switch database in rails console ?
---
### Author:  [@tgxworld](https://meta.discourse.org/u/tgxworld)
#### Post date: [August 19, 2016, 8:25am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/6 "2016-08-19T08:25:26Z")
`RAILS_DB=b_discourse rails console` or `RAILS_DB=b_discourse rails runner `
---
### Author:  [@tgxworld](https://meta.discourse.org/u/tgxworld)
#### Post date: [August 19, 2016, 8:35am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/7 "2016-08-19T08:35:15Z")
> [@Hammad\_Abbasi](#):
>
> rake admin:create RAILS\_DB=b\_discourse
Try `RAILS_DB=b_discourse rake admin:create`?
---
### Author:  [@Hammad\_Abbasi](https://meta.discourse.org/u/Hammad_Abbasi)
#### Post date: [August 19, 2016, 8:36am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/8 "2016-08-19T08:36:51Z")
> [@tgxworld](#):
>
> RAILS\_DB=b\_discourse rake admin:create
I did but didn’t work (creating on first site)
I am however able to use 2nd db using "RAILS\_DB=b\_discourse rails console "
Can i create an admin user or change password of existing user using this console ?
Please advice. Many Thanks for your Help
---
### Author:  [@tgxworld](https://meta.discourse.org/u/tgxworld)
#### Post date: [August 19, 2016, 8:52am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/9 "2016-08-19T08:52:30Z")
Hmm I’m not sure why it isn’t working for you. I just tested locally and it works fine.
> [@Hammad\_Abbasi](#):
>
> Can i create an admin user or change password of existing user using this console ?
Yup you can 🙂
>
---
### Author:  [@Hammad\_Abbasi](https://meta.discourse.org/u/Hammad_Abbasi)
#### Post date: [August 19, 2016, 8:59am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/10 "2016-08-19T08:59:34Z")
Below is my app.yml for 2nd site ( First site is using default - discourse\_hostname)
> before\_bundle\_exec:
> - file:
> path: $home/config/multisite.yml
> contents: |
> secondsite:
> adapter: postgresql
> database: b\_discourse
> pool: 25
> timeout: 5000
> db\_id: 2
> host\_names:
> - [community.mydomain.com](http://community.mydomain.com)
I just realized “RAILS\_DB=b\_discourse rails console” is also connecting to first database
---
### Author:  [@tgxworld](https://meta.discourse.org/u/tgxworld)
#### Post date: [August 19, 2016, 9:09am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/11 "2016-08-19T09:09:56Z")
Try `RAILS_DB=secondsite` instead.
---
### Author:  [@Hammad\_Abbasi](https://meta.discourse.org/u/Hammad_Abbasi)
#### Post date: [August 19, 2016, 10:49am UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/12 "2016-08-19T10:49:49Z")
Bingo - It worked 😃
Thanks alot
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [September 21, 2016, 11:28pm UTC](https://meta.discourse.org/t/creating-admin-using-rake-admin-create-in-multisite-configuration/48615/13 "2016-09-21T23:28:16Z")