Premier Support for MySQL 8.0 Ends April 2025, Extended Support Available until April 2026
Homebrew maintainers have announced that they will continue providing security updates for MySQL 8.0 beyond the end of its Premier Support by Oracle in April 2025. The Extended Support period will last until April 2026, ensuring that users of Homebrew's MySQL 8.0 package will continue to receive important security updates even after Oracle's support has ended.
MySQL 8.0 Security Updates for Homebrew
MySQL 8.0 is a popular open-source relational database management system (RDBMS) that is widely used for web applications, data warehouses, and other data-intensive applications. Security is a critical concern for any system that stores and processes sensitive data, and MySQL 8.0 includes a number of important security features, such as SSL/TLS encryption, password hashing, and access control.
SSL/TLS Encryption
MySQL 8.0 supports Secure Sockets Layer/Transport Layer Security (SSL/TLS) encryption, which ensures that data transmitted between the client and server is encrypted and protected from eavesdropping, tampering, and forgery. To enable SSL/TLS encryption in MySQL 8.0, you can use the --ssl-mode option when starting the MySQL server. For example, to require SSL/TLS encryption for all connections, you can use the following command:
mysql.server --ssl-mode=REQUIREDPassword Hashing
MySQL 8.0 includes a number of password hashing algorithms, such as SHA-256, that can be used to securely store and verify user passwords. To use password hashing in MySQL 8.0, you can use the PASSWORD() function to hash a password, and the OLD_PASSWORD() function to verify a hashed password. For example:
INSERT INTO users (username, password) VALUES ('john', PASSWORD('secret'));SELECT * FROM users WHERE username = 'john' AND password = OLD_PASSWORD('secret');Access Control
MySQL 8.0 includes a comprehensive access control system that allows you to restrict access to the database and its objects based on user privileges. For example, you can use the GRANT statement to grant privileges to a user, and the REVOKE statement to revoke privileges from a user. For example:
GRANT ALL PRIVILEGES ON *.* TO 'john'@'localhost';REVOKE ALL PRIVILEGES ON *.* FROM 'john'@'localhost';Continued Security Updates for Homebrew MySQL 8.0
With the announcement that Homebrew will continue providing security updates for MySQL 8.0 beyond the end of its Premier Support by Oracle, users can be assured that their systems will remain secure even after Oracle's support has ended. The Extended Support period will last until April 2026, giving users plenty of time to upgrade to a newer version of MySQL if they choose to do so. In the meantime, Homebrew's MySQL 8.0 package will continue to receive important security updates, ensuring that users' systems remain secure and protected from potential threats.
References
- MySQL 8.0 Reference Manual: https://dev.mysql.com/doc/refman/8.0/en/
- Homebrew's MySQL 8.0 Package: https://formulae.brew.sh/formula/mysql
- Oracle's MySQL Support Lifecycle: https://www.oracle.com/database/technologies/mysql/enterprise-edition/lifetime-support-policy.html