Hi,
I tried to install Moodle in localhost using WAMP 3.1.3 64Bit. And I'm using PHP version 7.0.29, MySQL version 5.7.21 (or MariaDB 10.2.14). But I'm unable to install Moodle on this. It says "Error reading from database" when I install. Below screen shows to me.
Can anyone please help me to fix this and install successfully???
I am not the expert on this, but maybe I can get you started.
Are you sure that the database is running? Have you started Apache and MySQL in your WAMP?
Are you sure that you entered the correct database username and password?
How, or maybe a better question, did you create a database before running moodle's install?
First thanks for your response.
Are you sure that the database is running?
Yes. I've checked that. It's working.
Have you started Apache and MySQL in your WAMP?
Yes. Everything is running.
Are you sure that you entered the correct database username and password?
Yes. I'm sure. I've checked many times
Did you create a database before running moodle's install?
Yes. I did.
I've checked old posts for solutions. And I tried that too. But nothing works....
And below is my config file
unset($CFG);
global $CFG;
$CFG = new stdClass();
$CFG->dbtype = 'mysqli';
$CFG->dblibrary = 'native';
$CFG->dbhost = 'localhost';
$CFG->dbname = 'moodle';
$CFG->dbuser = 'root';
$CFG->dbpass = '';
$CFG->prefix = 'mdl_';
$CFG->dboptions = array (
'dbpersist' => 0,
'dbport' => 3306,
'dbsocket' => '',
'dbcollation' => 'utf8mb4_unicode_ci',
);
$CFG->wwwroot = 'http://localhost/moodle';
$CFG->dataroot = 'E:\\wamp64\\moodledata';
$CFG->admin = 'admin';
$CFG->directorypermissions = 0777;
require_once(__DIR__ . '/lib/setup.php');
Could you share some information of your database logfile? Usually it gives some more information about the error you get.
I checked that log file. But nothing inside related to this issue. In fact, I checked all the log files. But i can't find anything related to this
Did you try dbtype "mariadb"? Can you reach the database with mysql command as root?
I tried that too. that's not working
drop the database and retry to install Moodle.
I am also facing the same problem when I tried to upgrade moodle 3.8 to 3.9.
Please help me resolve the problem.
Thanks & regards
Fatima
(Edited by Mary Cooch to change subject title- original submission Tuesday, 16 June 2020, 7:33 AM)
I suggest trying what the message says. Delete your database, create a new one and try again.
Actually, i tried that. But nothing works
What is your database server? Let's start there - is it mysql or mariadb?
Does the user you created have the necessary permissions on the database (read,write, etc)?
That error suggests that you are connecting the database server but something is wrong with the database itself.
Did you go through the specific instructions for whatever database you have found here:
https://docs.moodle.org/35/en/Installing_Moodle#Create_an_empty_database
For those still getting the "error reading from database" message: I changed 'dbcollation' in the moodle config file (config.php) from 'utf8mb4_unicode_ci' to 'utf8_general_ci' and now it works.
Probably would be better to change the database encoding instead of moodle settings but my host does not allow the change.
Mil gracias, hice el mismo cambio y funcionó, now it works, but en Moodle 3.6.3+
Thanks for the solution,,,,, it has been an error for a whole week.... after transferring moodle files to cpanel wit its database.
Oh man, you saved me hours!!, I was having too the "error reading from database" when creating a new user on moodle 3.7.2 , i made the change you suggested and everything is working now.
But, which could be the implications of changing the dbcollation on a production site?
The 'utf8_general_ci' doesn't support emoji etc. So i went it 'utf8mb4_general_ci' which solved my problem.
We had the same issue after we upgraded our site to version 3.6.10. The following CLI script to convert to the new Character set and Collation in the database solves the problem.
php admin/cli/mysql_collation.php --collation=utf8mb4_unicode_cihttps://docs.moodle.org/36/en/MySQL_full_unicode_support
