As long as they fit within your MySQL VPS plan’s storage limit, there is no limit to the number of databases. In general, you will have one for each site that requires a database.