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
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).