Mysql openemr user password change

Management and Administration
1

cravaus wrote on Thursday, May 14, 2015:

I messed up and made my mysql openemr user password public (not my log in password but the database password). I need to change it. I know it is contained in sqlconf.php. But changing it there is not sufficient. So, what is the procedure?

2

visolveemr wrote on Thursday, May 14, 2015:

Hello Craig Tucker,

To change mysql password for user “openemr”, please follow the below steps for linux machine,

mysql -u root -p
use mysql;
update user set password=PASSWORD('your_new_password') where User='openemr';
flush privileges;

Thanks
OpenEMR Customization/Support Team,
ViSolve Inc
services@visolve.com | Phone: 408-850-2243
Demo’s @ ViSolve Demo Library

3

fsgl wrote on Thursday, May 14, 2015:

See this.

4

cravaus wrote on Thursday, May 14, 2015:

Thanks, I had the old password, in a previous post I put my password out there, I did not recognize it. Thought it was an old one. Then I realized it is indeed current. Yikes.

So ViSolve’s worked fine. I will keep fsgl’s in mind for when I really blow it and have no idea of the password!

Thanks again.

Craig