Using root was a method of troubleshooting. This is the scenario better explained:
I was moving a custom version of OpenEMR from one instance on Amazon to the new instance on GCP. I am also doing an upgrade from 6.01 to 7.01. The GCP instance was treated as a development server until we go live with production. I had imported the documents directory into the new system and this is where the problems started happening. I used the old certificates and the sixa and sixb files and i was unable to access mySQL during install of even a new system and after much struggling I saw it was related to the sites/documents/certificates file. I removed the public and private keys, removed the sixa and sixb files and everything started to work.
As far as phpmyadmin goes. Phpmyadmin is securely installed and is a powerful tool for troubleshooting data issues and is specifically necessary when I have modules that are transmitting raw data to different targets. Viewing the logged the raw data sent gives me both a micro and macro view of what is happening and is a vital tool when it comes to troubleshooting.
Do I know what I am doing? Well, I’ve been learning / developing OpenEMR since 2014 so I would hope so.