Changing MySQL Server Settings

(Craig Tucker) #1

I am having to upgrade to MariaDB 10. I have successfully moved my files over from MariaDB 5. MariaDB 10 runs on a different port. It also does not like localhost and prefers so I need to change these items out. Is there a file I can edit? Do I need to do an installation process again?

(MedDev) #2

The config is in: sites/default/sqlconf.php

$host = ‘’;
$port = ‘3306’;
$login = ‘your_login’;
$pass = ‘your_passwd’;
$dbase = ‘your_db_name’;

(Craig Tucker) #3

Thanks, that got me a step further, I changed $host to and $port to 3307 but apparently it was not hitting all the server settings:

Warning: mysqli_real_connect(): (HY000/1045):
Access denied for user ‘openemr’@‘localhost’ (using password: YES)
in /volume1/homes/Craig/www/openemr/vendor/adodb/adodb-php/drivers/ on line 123
Fatal error: Call to undefined function text()
in /volume1/homes/Craig/www/openemr/library/ on line 155

So, I figured it must be in the database. I edited the openemr user login information in phpMyAdmin. I changed localhost out to and re entered my password. It all came back.

(ViSolve) #4

Hi @Craig_Tucker

The error message you have shared will be displayed when the mentioned user does not have the privilege to access the DB.
So lets first check, if the user has the right privilege.
To retrieve all Users information in MariaDB, you can execute the following SQL statement:
SELECT * FROM mysql.db \G;