A stored function in MySQL is a reusable program that is stored in the database and can be called multiple times. It performs a specific task and returns a single value as a result. Stored functions are commonly used for calculations, data manipulation, and complex data operations.