I’m stuck on step 2 of the OpenEMR installation.
I’m using OpenEMR version 5.0.2 on Linux.
I’m using OpenEMR on a Linux server running PHP 7.1
Below is the message I get when I try to proceed.
Connecting to MySQL Server… OK.
Creating database… ERROR. Check your login credentials. unable to execute SQL: ‘create database openemr character set utf8 collate utf8_general_ci’ due to: Access denied for user ‘abalheal_root’@‘localhost’ to database 'openemr
It would be helpful to know which Linux distro it is, that’s what I meant by asking what OS it is.
There’s an issue with Debian and using the root account.
Is this a separate account you’ve created for this purpose and not the actual root MySQL account? There can be issues using an actual root account. It looks as though it isn’t the actual root account.
“If you are on Debian 9 using MariaDB and have root access problems with the installer, either disable the unix_socket plugin, or create an additional user with root privileges and use this new user as the “root” user for installation”
It also prevents login for root when not on the console.
Do you see anything in /var/log/apache/error.log?
What do you get when you run this at the MySQL terminal:
SELECT host, user FROM mysql.user;
Going by the error message, it doesn’t sound as though you’re hitting the issue of having a too-complex a password: