Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Digitlocean App Droplet Database Password

Esteban Munoz   ( User )

Commented 2 years ago

Hi there, I'm trying to connect to the database on a fresh deploy through DigitalOcean app droplet (https://marketplace.digitalocean.com/apps/akaunting). I'm missing the Database password. It states that the database configuration in based on DO LAMP, but I'm missing file `/root/.digitalocean_password`.

Any ideas?

Esteban Munoz   ( User )

Commented 2 years ago

No db password on user `ak_admin`.

1. Create new user:

```shell
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
```

see: https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

2. Allow remote access

see: https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql

3. Think about security risk vs. usability

Pavel Mironchik   ( User )

Commented 2 years ago

You can find the username and password in the `.env` file.

Please login or register to leave a response.

Showing 1 to 3 of 3 discussions