MariaDB [moodle]> show tables like '%h5p%';
+----------------------------------+
| Tables_in_moodle (%h5p%) |
+----------------------------------+
| mdl_h5p |
| mdl_h5p_contents_libraries |
| mdl_h5p_libraries |
| mdl_h5p_libraries_cachedassets |
| mdl_h5p_library_dependencies |
| mdl_h5pactivity |
| mdl_h5pactivity_attempts |
| mdl_h5pactivity_attempts_results |
+----------------------------------+
8 rows in set (0.000 sec)
+----------------------------------+
| Tables_in_moodle (%h5p%) |
+----------------------------------+
| mdl_h5p |
| mdl_h5p_contents_libraries |
| mdl_h5p_libraries |
| mdl_h5p_libraries_cachedassets |
| mdl_h5p_library_dependencies |
| mdl_h5pactivity |
| mdl_h5pactivity_attempts |
| mdl_h5pactivity_attempts_results |
+----------------------------------+
8 rows in set (0.000 sec)
database created :
MariaDB [moodle]> CREATE DATABASE moodle DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
the moodle DB user's perms set by :
MariaDB [moodle]> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO moodleuser@localhost;
the moodle DB user's perms set by :
MariaDB [moodle]> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO moodleuser@localhost;