Hi guys, what is the openmrs_user password and where in the source code is this stored?
If not, you may want to get started with contributing from this guide ,
Thank you for the prompt response Nathan. Maybe just a bit of context to my issue;
I’m trying to run openmrs locally and after i complete the initial setup, i get an error that says that openmrs_user password is not right. This i think has to do with mysql server default being caching_sha2_password and not password.
I just need to know what default password is used for the openmrs_user on initial setup.NOTE! this is not the same as the ‘root’ password of mysql server.
@shlapolosa if you didn’t specify a password during the installation process then Admin123 should log you in with username admin
Are you using mysql version greater than 5.7?
indeed i’m using 8.0.12 MySQL Community Server - GPL
Then it really a mysql caching_sha2_password password issue. i had this and had to revert to mysql 5.7 but any thing less than 8 will do. this is because mysql versions less than 8 uses authentication plugin mysql_native_password while 8.* uses caching_sha2_password. You could revert as well or maybe some one has a better solution.
@shlapolosa you can read more about the mysql versioning and authentication plugin here https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
@shlapolosa, its been 2 years, was this resolved for you?
@dkayiwa Is this a non-existent problem as at now for other users?
OpenMRS 2.x (Specifically 2.2) has a slightly similar problem: Once the initial setup is complete the default credentials don’t work, on investigation, I found that the users table has the password setup as expected but the username for the default user is blank- I don’t know whether that is intentional.
The workaround is to UPDATE the particular users table row with the ‘admin’ username.
Did you try out the latest release?