How to change default mysql password

Example of run-time properties file

   #Auto generated by OpenMRS initialization wizard
    #Tue Mar 05 15:01:15 EAT 2019
    encryption.vector=4EjE8q/78ntmOJzwEdyGpA\=\=
    connection.url=jdbc\:mysql\://localhost\:3306/EmrApiTest3?autoReconnect\=true&sessionVariables\=default_storage_engine%3DInnoDB&useUnicode\=true&characterEncoding\=UTF-8
    module.allow_web_admin=true
    connection.username=**USER**
    auto_update_database=false
    encryption.key=KijkSt2Apx1nDJHpJ3nw/A\=\=
    connection.driver_class=com.mysql.jdbc.Driver
    connection.password=**PASSWORD_YOU_SET_IN_mySQL
1 Like

After changing my password it didnt reflected in this runtime properties… After i tried to change it manually…but same issue is there…it effects the backup…

no in the openmrs run-time properties file, it cant change automaticaly , you have to manually change it

take note of the exact user and corresponding password in your mySQL. put the same user and password in your run-time properties file

2 Likes

@mithu are you able to access your mysql database using your user and password?

2 Likes

I tried the same and the issue is still there…

Yes…I can able to access…

1 Like

can you paste your server logs in pastebin and post the link here??

are you runing sdk?

1 Like

yeah…im running sdk…

can you follow this on setting up the sdk https://wiki.openmrs.org/display/docs/OpenMRS+SDK