and it is fairly straightforward. I have an existing installation of passbolt and I need to change the password on the DB. I see the settings for the docker file, but how do I log onto the DB and make the change in password to the new one being used in the edited docker file?
It’s actually a user with a password, and the user has been granted rights to the database. Here are some general instructions that should help.
To see the database users, you have to enter into the container while it’s running with something like: docker exec -it <your mariadb container name here> bash
which would start an interactive shell in the running container.
Then log into MariaDB as the root user with mysql command or mysql -u root.
See all the users for your database: SELECT User, Host FROM mysql.user;
Hi garrett, thanks very much for the quick response. I’m running into the ERROR 1045 (2800) Access denied for user ‘root’@‘localhost’ which I have encountered before. I have tried logging in with the ‘passbolt’ user and the default password (mysql -u passbolt -p) and am able to login but I get an ERROR 1142 (42000): SELECT command denied to user ‘passbolt’@‘localhost’ for table ‘mysql’, ‘user’.
In the docker .yaml file there is a line that is written as follows: MYSQL_RANDOM_ROOT_PASSWORD: "true"
I suspect that if I use mysql -u root -p and know the password for root, I can complete the commands you have listed. I do not recall giving a password to a root user for the MariaDB database.
Hi garrett, thank you again for your reply. Do you know if the installation process prompts for a root password? I can just install again since I really have no data yet in the passbolt. If it should have prompted I most likely know the root password I would have used, however I did try that password with mysql -u root -p. I don’t know what that line in the .yaml file is doing. Does it create a new password each time the docker container is brought up?