Stuck on step 2, "Connecting to MySQL Server... ERROR. Check your login credentials. unable to connect to database as root"

Hi, I had the same problem in local host:

I always try to see what is the problem. In this case we can’t acess databank with root user. Why?

OpenEMR asks for a creation of a series of 10 characters passwords, inclusive a pw for root, without it we have a message error and instalation stops waiting for the password.
Unfortunately, root alread exists with “password is nothing”. When phpmyadmin checks your input, it denies acess.
It is a kind of “logic bug” from OpenEMR instalation file.

So first (before everything else),
go to xamp console and open phpmyadmin:

In phpmyadmin create a new “root” user with a long password (same that you will use when configuring openemr).

Phpmyadmin will tell you that root already exists, don’t bother, create a new root user (your pc won’t blow up, promisse!)

the same password you created for root is inserted here:

V E R Y I M P O R T A N T S T E P:

To acess root you also need to insert the password in config.inc.php file:

Attention:
if you tryed a lot of times, you can find this error:

Always read the erro message: cant create openemr because… it already exists. In some way You’ve created it before while trying to install OpenEMR. Solution → go to phpmyadmin delete openemr databank and restart the instalation process.

Then you will see this window:

Why openemr don´t shows us the answer, instead send us to another page? Anyway here is the answer:

This is the apache configuration file in xampp localhost windows:

finally:

OpenEMR is a wonderfull computer application, I’Ve been using it for year, congrats to the community.

Best regards from Brazil
Paulo Kanda

1 Like