I currently have a rather large database in access that I need to convert over to MySQL for my new webhost. What would be the best method to go about this ...

Not only have you configured MySQL 8 for remote connections, you’ve also created a user with access to all databases and connected to the remote server with both the command line and a GUI.