That is not what the linked article says, it is perfectly possible to connect Shiny with almost any local database server, including MySQL for sure, you just need to configure proper access rights and make sure that the database is reachable from outside your local network (assuming your Shiny app is deployed outside your local network).
You need to give more details about your setup and what have you tried so far that is not working, for us been able to help you.