What is the default user password?

Ask OpenMRS
1

Hi guys, what is the openmrs_user password and where in the source code is this stored?

2

welcome @shlapolosa,

If not, you may want to get started with contributing from this guide ,

Otherwise did you get chance to look at this , from here ?

1 Like
3

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.

1 Like
4

@shlapolosa if you didn’t specify a password during the installation process then Admin123 should log you in with username admin

5

04
042406×1566 303 KB

6

Are you using mysql version greater than 5.7?

7

indeed i’m using 8.0.12 MySQL Community Server - GPL

8

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.

cc @dkayiwa @wyclif

1 Like
9

@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

10

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

11

Did you try out the latest release?