Unable to login as admin (user not found)

[3246]

Help! I set up a new Ghost website using example.com, registered as admin and then changed the domain to examplesomething.com.

I am unable to login and when I try to reset my password Ghost tells me that 'user not found'

[girish]

@3246 Just to double check, you are logging into admin UI , correct ? The one is /ghost ?

You can check if you are entering the email id correctly. Web Terminal -> MySQL button on top, press enter and then:

mysql> select name,email from users;
+--------+------------------+
| name   | email            |
+--------+------------------+
| Girish | test@cloudron.io |
+--------+------------------+
1 row in set (0.00 sec)

[3246]

Ah, thanks @girish. Can we add info to the doc about how to manage the database for Ghost, please?

[nebulon]

I guess this is nothing specific to ghost in this case. The webterminal shows buttons for convenience depending on the addons an app uses to get access to the database via cli.

[girish]

If you know some SQL, you can navigate around the database . show tables and then select * from <tablename> , show create table <tablename> are some commands to know. But these things are very specific to each app and each app's database keeps changing for every release. It would be hard to track these changes via docs.