Access denied for user 'root'@'localhost' (using password: YES)

Amateur-God · February 27, 2025, 6:05pm

i restarted the server then went to start the containers and just got stuck on waiting for configurator, so i cancelled it, ran the down command, then re ran the up command but without the -d so i could see any errors and this was just spammed,

db-1 | 2025-02-27 17:56:44 33 [Warning] Access denied for user ‘root’@‘localhost’ (using password: YES)

the password in the compose file works as i removed the health check lines, started the db with up -d db and then tested it with

docker exec -it db-1 mysql -u root -p

elhananjair · February 27, 2025, 6:23pm

Check this documentation to resolve the issue:

github.com

frappe/frappe_docker/blob/main/docs/troubleshoot.md#fixing-mariadb-issues-after-rebuilding-the-container

1. [Fixing MariaDB issues after rebuilding the container](#fixing-mariadb-issues-after-rebuilding-the-container)
1. [docker-compose does not recognize variables from `.env` file](#docker-compose-does-not-recognize-variables-from-env-file)
1. [Windows Based Installation](#windows-based-installation)

### Fixing MariaDB issues after rebuilding the container

For any reason after rebuilding the container if you are not be able to access MariaDB correctly (i.e. `Access denied for user [...]`) with the previous configuration. Follow these instructions.

First test for network issues. Manually connect to the database through the `backend` container:

```
docker exec -it frappe_docker-backend-1 bash
mysql -uroot -padmin -hdb
```

Replace `root` with the database root user name, `admin` with the root password, and `db` with the service name specified in the docker-compose `.yml` configuration file. If the connection to the database is successful, then the network configuration is correct and you can proceed to the next step. Otherwise, modify the docker-compose `.yml` configuration file, in the `configurator` service's `environment` section, to use the container names (`frappe_docker-db-1`, `frappe_docker-redis-cache-1`, `frappe_docker-redis-queue-1` or as otherwise shown with `docker ps`) instead of the service names and rebuild the containers.

Then, the parameter `'db_name'@'%'` needs to be set in MariaDB and permission to the site database suitably assigned to the user.

This step has to be repeated for all sites available under the current bench.

This file has been truncated. show original

Amateur-God · March 5, 2025, 6:45pm

I’m unable to run any of this as i am unable to start the stack as the stack fails the health check due to the ping from the health check getting this

db-1 | 2025-02-27 17:56:44 33 [Warning] Access denied for user ‘root’@‘localhost’ (using password: YES)

Amateur-God · April 22, 2025, 11:38am

any further help on this as like i said im unable to start the stack as its the health check thats failing, everything else works fine

ive disabled the healthcheck and made it not a requirement and everything works perfect, its just the healtcheck fails and was preventing it from starting

trustedcomputer · April 22, 2025, 1:21pm

Probably best if you can post here your whole “db” service from your compose file so we can take a look. Otherwise we’ll just be taking guesses in the dark. Just make sure to redact your password.