Moodle Installation error – Database MySQL version 5.5.31 is required and you are running 5.5.5.10.1.13

Yesterday while I was installing the Moodle 3.1 on my recently formatted laptop for development purpose in a XAMPP environment, I faced a peculiar error which halt the installation process on the Server checks page.

The installation process was showing the error in the very first line as  “version 5.5.31 is required and you are running 5.5.5.10.1.13” for MySQL Database – 5.5.5.10.1.13-Mariadb.

After performing a quick search through Google forums, I stumbled upon the following solution suggested by Marina Glancy in one of the Moodle forums which worked for me:

Moodle Installation error - Database MySQL version 5.5.31 is required and you are running 5.5.5.10.1.13you need to edit your config.php and specify database as “mariadb” instead of “mysqli”.

To address the same issue, a new Moodle tracker issue is opened with ID – MDL-51080 here. The tracker issue is still unresolved so all the Moodlers who faced this issue can continue by following the above solution till any update is released.

Going in the technical details of the issue on the tracker issue, I found:

WHAT ACTUALLY HAPPENS:
Moodle’s upgrade check gives only the error: “version 5.5.31 is required and you are running 5.5.5.10.0.20”. This error leads to things like issue #45070 and not the fix in the blog.

WHAT SHOULD HAPPEN:

the mysql-version checking code should generate an explicit recommendation “please change dbtype to mariadb in config.php” if it detects -10. in the version string.

The same issue might occur during the upgrade process also as many OS have switched from MySql to MariaDB.

Have you also faced the same problem while installing or upgrading your Moodle site? How do you overcame the problem? Share your creative ideas in the comments section below.

Jaswinder Singh

Jaswinder Singh, passionate about using Moodle in improving the Indian Education System and reaching the students in far flung areas where still education seems to be a impossible prospect of life. He is the author of the popular Moodle Book “How to use Moodle 2.7”. In October 2016, Jaswinder was elected as the Moodle User’s Association Committee member – the first to make it from India.

Related Articles

  • Khabib

    Thanks alot for the information mate, I very appreciate this. I was stuck with this trouble almost a week, then found this post that’s very helpfull to me badly. Keep it up mate.!

    • Many Thanks,
      Let me know if you need any help with Moodle.