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.
Step 3
Configuring OpenEMR…
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’s MySQL. And according to the email I just got from my hosting company, it’s a shared hosting server and they are the only ones with root access. Is there anyway to install OpenEMR without root?
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:
Note that you’re not using MySQL, you’re using MariaDB. It’s important to know the distinction because advice regarding issues relates to specific software.
Admin password of MariaDb doesn’t seem to work
Can’t setup/clean reinstall MariaDB/MySQL on Debian Stretch 9