Chances are, you’re already using the latest version and don’t need to do anything at all. It’s crucial to keep MySQL up to date, but you need to know its version before upgrading. And as 5.6 is no longer supported and is susceptible to bugs and security risks, you should at least update to 5.7. While WordPress supports MySQL versions all the way back to 5.6, 8.0 works perfectly with it. As for major updates, it’s worth it unless crucial parts of your server are incompatible. Even minor updates are worth the trouble, though the new built-in auto-updater will likely handle those for you. It’s almost always best to keep up with the latest stable version of MySQL. There are some upgrade considerations and backward incompatibilities you’ll need to know about, but for a majority of sites, they won’t cause issues. And for developers who can make use of the new functions, the benefits are more numerous than can be quickly listed. It’s faster and more secure - changes can be observed instantly upon activating it. Support EOL for macOS v10.14īut while MySQL 5.7 is still supported, making the switch to the latest version is definitely worth your time.

In addition, 5.7 has not been deprecated and will not be until 2023. Most people don’t upgrade because either they don’t know about the latest MySQL version, or they don’t want to take the time to update it. Why is this? And which is best, MySQL 5.7 or 8.0? Many servers these days are still running on MySQL 5.7 (the latest version before the jump to 8.0), even though a newer and better version exists. Learn how to check for yourself right here ⬇️ Click to Tweet but not all hosts will continue to keep it updated. MySQL runs in the background of 90% of websites 😲. When it comes to any software on your website, it’s almost always best to keep it at the latest version. What’s new in MySQL 8.0.Īnd with every update of MySQL comes a whole slew of bug fixes, patching up errors that could be an annoyance at best or cause you serious trouble at worst.

Even if these extra features don’t affect you, more recent MySQL versions are more secure, better optimized, and faster. You don’t want anyone unwanted to be able to modify that.īesides that, a new version means new features and general improvements for what’s already there. All sorts of important info are stored there, such as your WordPress posts and all other kinds of sensitive bits. They may even be able to mess with your database. Even the tiniest hole in your security could be a vector for attackers to slip through and take over. It’s never good to have outdated software on your server. But there are quite a few reasons why this is a bad idea. As long as your server and database are working fine, it may be tempting to ignore an outdated piece of software. Manual server maintenance is not a fun task, especially if you’re not very familiar with your webserver’s inner workings.

Install mysql client brew