Ask, reply and learn. Join the community of Akaunting.
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?
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
You can find the username and password in the `.env` file.
Showing 1 to 3 of 3 discussions