Documentation - V-235168

Title

The MySQL Database Server 8.0 must prohibit user installation of logic modules (stored procedures, functions, triggers, views, etc.) without explicit privileged status.

Description

<VulnDiscussion>Allowing regular users to install software, without explicit privileges, creates the risk that untested or potentially malicious software will be installed on the system. Explicit privileges (escalated or administrative privileges) provide the regular user with explicit capabilities and control that exceed the rights of a regular user. Database Management System (DBMS) functionality and the nature and requirements of databases will vary; so while users are not permitted to insta...

Fix Text (Documentation Requirement)

MySQL requires users (other than root) to be explicitly granted the CREATE ROUTINE privilege in order to install logical modules. Check user grants using the SHOW GRANTS and look for appropriate assignment of CREATE ROUTINE. For example - REVOKE CREATE ROUTINE ON mydb.* TO 'someuser'@'somehost';