title: Php version and compatibility with Mysql 8
body: <p>I need to setup a database server which will be serving 4-5 different php applications - each hosted in their own hosting server.</p>
  
  <p>All these php applications are using different php versions e.g. App 1 is still using php 5.5, App 2 has php 7.0, App 3 has php 7.2.8, App 4 has php 7.2.28, App 5 has php 7.4</p>
  
  <p>My current database server is on a separate server which has mysql 5.5. I am planning to setup mysql 8 in a brand new server and move all the data from older server to new server. I will manually dump, fix any compatibility issues and restore into Mysql 8.  </p>
  
  <p>My questions are: 
  Would all these different php versions work with this latest MySQL 8? I have learnt there is different authentication in mysql 8 but as I'll be setting up new users in this new setup, will that still create any issues in the older php apps?</p>
  
  <p>Also, should I consider using latest MariaDB over MySQL.</p>