How do i access openmrs standalone database?


(Herbert Yiga) #1

I want to uplaod my demo data file to my openmrs stand alone data base,but the password i get from openmrs-standalone-runtime doesnot work aftr runing mysql -u openmrs -p


(Burke Mamlin) #2

Did you follow the instructions on the OpenMRS Standalone page? Maybe you’re running the command in the wrong folder, so running your local copy of MySQL instead of the embedded version.


(Herbert Yiga) #3

@burke,hi thnks it looks like i was operating on a different folder let me try to figure it out will be back here


(tendo kiiza Martyn) #4

@herbert24 was @burke 's helpful?


(Herbert Yiga) #5

yeah burke has a great idea that am going to sort and i come back here


(Herbert Yiga) #6

@Burke ,@Tendo This is my openmrs stand alone runtime file((( #Last updated by the OpenMRS Standalone application. #Mon Feb 12 01:23:35 PST 2018 vm_arguments=-Xmx512m -Xms512m -XX:PermSize=256m -XX:MaxPermSize=256m -XX:NewSize=128m connection.username=openmrs connection.url=jdbc:mysql:mxj://127.0.0.1:3316/openmrs?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&server.initialize-user=true&createDatabaseIfNotExist=true&server.basedir=database&server.datadir=database/data&server.collation-server=utf8_general_ci&server.character-set-server=utf8&server.max_allowed_packet=96M connection.password=x.WlgvyHDlOw module.allow_web_admin=true tomcatport=8081 application_data_directory=appdata auto_update_database=false

)))

using windows operating system,i have cd to my database folder of the stand alone, then to bin folder. After i have run mysql -u openmrs -p The above command prompts for a password and i put x.WlgvyHDlOw as from the runtime file above. But it still fails to connect to the database


(Herbert Yiga) #7

i keep on getting this error after entering the password ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)


(Shelter Editor) #8

I am not sure if your problem already solved but I just found the solution try this, your sql port is 3316

Blockquote

mysql -u openmrs -p --port=3316 --host=127.0.0.1

Blockquote


(Herbert Yiga) #9

@dailyshelter
thanks much though i arleady sorted the problem


(Daniel Kayiwa) #10

@herbert24 when you ask for help but figure it out yourself, it helps replying to yourself and share what you did to fix it. It also saves time for those who invest resources trying to help you.


(Herbert Yiga) #11

@dkayiwa true and i am going to implement that