How to obtain the name of month of a given date using the MONTHNAME() function?

MONTHNAME(date) is a MySQL built-in function that returns the name of month from a given date. For example:

SELECT MONTHNAME('2023-02-03'), MONTHNAME(NOW());
  -- +-------------------------+------------------+
  -- | MONTHNAME('2023-02-03') | MONTHNAME(NOW()) |
  -- +-------------------------+------------------+
  -- | February                | November         |
  -- +-------------------------+------------------+

Reference information of the MONTHNAME() function:

MONTHNAME(date): str
  Returns the full name of the month for date. The language used for the
  name is controlled by the value of the lc_time_names system variable.

Arguments, return value and availability:
  date: Required. The date to extract the name of month from.
  str: Return value. The name of month.
  Available since MySQL 4.

⇒ NOW() - Start Time of Execution

⇐ MONTH() - Month of Year

⇑ MySQL Functions on Date and Time

⇑⇑ MySQL Function References