Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-85485

Require MySQL 8.0.1 in environment.xml for Moodle 4.5

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 4.5.5
    • Administration
    • MOODLE_405_STABLE
    • MDL-85485-environmentmysql-405
    • MDL-85485-environmentmysql-500
    • MDL-85485-environmentmysql
    • Hide

      Steps

      1. Set up MySQL 8.0.0.
      2. Download and extract Moodle 4.5.
      3. Create a MySQL database for Moodle, for example, mdl85485, and corresponding user account, for example, mdl85485@localhost.
      4. Attempt to install Moodle 4.5, for example, using the command line php admin/cli/install.php --wwwroot=https://moodle.example.com --dbtype=mysqli --dbhost=localhost --dbname=mdl85485 --dbuser=mdl85485 --dbpass=yourpassword --fullname=Test\ Site --shortname=Test\ Site --adminpass=Password-123 --agree-license --non-interactive.

      Expected results

      == Environment ==
      		 
      !! database mysql (8.0.0) !!
      		 
      [System] version 8.0.1 is required and you are running 8.0.0 -

      Show
      Steps Set up MySQL 8.0.0. Download and extract Moodle 4.5. Create a MySQL database for Moodle, for example, mdl85485 , and corresponding user account, for example, mdl85485@localhost . Attempt to install Moodle 4.5, for example, using the command line php admin/cli/install.php --wwwroot= https://moodle.example.com --dbtype=mysqli --dbhost=localhost --dbname=mdl85485 --dbuser=mdl85485 --dbpass=yourpassword --fullname=Test\ Site --shortname=Test\ Site --adminpass=Password-123 --agree-license --non-interactive . Expected results == Environment == !! database mysql (8.0.0) !! [System] version 8.0.1 is required and you are running 8.0.0 -
    • Hide

      Code verified against automated checks.

      Checked MDL-85485 using repository: https://github.com/leonstr/moodle

      More information about this report

      Built on: Tue May 13 09:48:19 UTC 2025

      Show
      Code verified against automated checks. Checked MDL-85485 using repository: https://github.com/leonstr/moodle MOODLE_405_STABLE (0 errors / 0 warnings) [branch: MDL-85485-environmentmysql-405 | CI Job ] MOODLE_500_STABLE (0 errors / 0 warnings) [branch: MDL-85485-environmentmysql-500 | CI Job ] main (0 errors / 0 warnings) [branch: MDL-85485-environmentmysql | CI Job ] More information about this report Built on: Tue May 13 09:48:19 UTC 2025

      Under Database requirements the Moodle 4.5 release notes say MySQL 8.0. However Moodle won't install with MySQL 8.0.0 because role was a reserved word, and is used by mdl_course_completion_criteria.role. This restriction was removed in MySQL 8.0.1.

      There's pull request #1348 to update the release notes, but should this be approved a corresponding change to the environment checks should be made.

            leonstr Leon Stringer
            leonstr Leon Stringer
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.