In normal VPS hosting, the service providers offer a server where you can install software like MySQL, Nginx, Apache, etc. But in MySQL VPS hosting, the service providers have already installed MySQL and you can use it without worrying about the management of the database because the hosting providers are responsible for its management and security.  If you would like to configure and manage MySQL database and other software on your own, then purchase the normal VPS hosting service. But if you want to use the MySQL database in a VPS hosting but without the administrative hassles, go for MySQL VPS hosting.