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 127.0.0.1 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 = ‘127.0.0.1’;
$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 127.0.0.1 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/adodb-mysqli.inc.php on line 123
Fatal error: Call to undefined function text()
in /volume1/homes/Craig/www/openemr/library/sql.inc 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 127.0.0.1 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;

Thanks,
ViSolve