Hi, I am trying to install Open EMR 7.0.0 on Synology DS 415+
Apache 2.4, PHP 7.4, MariaDB and phpmyAdmin are installed and working on the same NAS.
Virtual Host is configured and ssl work fine.
The dns correctly resolves the domain.
- I created a database in MySQL for OpenEMR. First, log in to MySQL as the database root user:
sudo mysql
- Once you are logged into MySQL as the database root user, create a database named openemr with the following command:
MariaDB [(none)]> CREATE DATABASE openemr;
and
MariaDB [(none)]> CREATE USER ‘openemr’@‘localhost’ IDENTIFIED BY ‘PASSWORD’;
and check
MariaDB [(none)]> SELECT host, user FROM mysql.user;
±----------±--------+
| host | user |
±----------±--------+
| 127.0.0.1 | root |
| ::1 | root |
| localhost | openemr |
| localhost | root |
±----------±--------+
- Next, I granted the new user permission to the openemr database:
MariaDB [(none)]>GRANT ALL PRIVILEGES ON openemr.* TO ‘openemr’@‘localhost’;
Then I enabled these changes, entering the following command:
MariaDB [(none)]>FLUSH PRIVILEGES;
but at step 3, say “Connecting to MySQL Server… ERROR. Check your login credentials. unable to connect to database as user: ‘openemr’”
Can anyone give me some advice what I am doing wrong? Thanks for reading !
Adrian
