Installing MySQL on our system allows us to safely create, drop, and test web applications without affecting our live website’s data. There are many ways to use MySQL on our system, but the best way is to install it manually. The manual installation allows us to learn more about the system and provides more control over the database.
Manual installation of MySQL has several benefits:
- Backing up, reinstalling, or moving databases from one location to another can be achieved in a second.
- It provides more control to how and when MySQL server starts and closes.
- We can install MySQL anywhere, like in a portable USB drive.