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
anilkarki
(Anil Karki)
August 25, 2019, 7:50am
#2
Try this…
mysql -uopenmrs-user -pP@ssw0rd openmrs
1 Like
javed910
(Javed Shaikh)
February 21, 2022, 9:18pm
#3
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).
gsluthra
(Gurpreet Luthra)
February 23, 2022, 10:54am
#4