Cannot login to db with "mysql -uopenmrs-user -ppassword openmrs" command in bhamni V0.92

I am not able to login in to database with “mysql -uopenmrs-user -ppassword openmrs” in the latest bahmni V.0.92 but it was possible in v0.91 release. It showing error ERROR 1045 (28000): Access denied for user 'openmrs-user'@'localhost' (using password: YES) Can you please help me to figure out the issue as i’m stuck on my work right now ?

Thanks and regards

Try this…

mysql -uopenmrs-user -pP@ssw0rd openmrs

1 Like

I am also getting the same issue on my windows machine. Access denied for user ‘openmrs’@‘localhost’ (using password: YES)

2022-02-21 16:17:22,915 INFO [org.hibernate.jpa.internal.util.LogHelper] (default task-1) HHH000204: Processing PersistenceUnitInfo [name: openmrs-userstore] 2022-02-21 16:17:22,915 WARN [org.hibernate.orm.connections.pooling] (default task-1) HHH10001002: Using Hibernate built-in connection pool (not for production use!) 2022-02-21 16:17:22,915 INFO [org.hibernate.orm.connections.pooling] (default task-1) HHH10001005: using driver [com.mysql.cj.jdbc.Driver] at URL [jdbc:mysql://localhost:3316/openmrs?useSSL=false&characterEncoding=UTF-8] 2022-02-21 16:17:22,915 INFO [org.hibernate.orm.connections.pooling] (default task-1) HHH10001001: Connection properties: {password=****, user=openmrs} 2022-02-21 16:17:22,915 INFO [org.hibernate.orm.connections.pooling] (default task-1) HHH10001003: Autocommit mode: false 2022-02-21 16:17:22,915 INFO [org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl] (default task-1) HHH000115: Hibernate connection pool size: 20 (min=1) 2022-02-21 16:17:22,915 WARN [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator] (default task-1) HHH000342: Could not obtain connection to query metadata : null 2022-02-21 16:17:22,915 INFO [org.hibernate.dialect.Dialect] (default task-1) HHH000400: Using dialect: org.hibernate.dialect.MySQL55Dialect 2022-02-21 16:17:22,915 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-1) SQL Error: 1045, SQLState: 28000 2022-02-21 16:17:22,915 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-1) Access denied for user ‘openmrs’@‘localhost’ (using password: YES).

See this: https://bahmni.atlassian.net/wiki/spaces/BAH/pages/49545219/Connecting+to+various+databases