Convert Access to MySQL
Use Bullzip
http://www.bullzip.com/products/a2m/info.php
Related Posts
10 MySQL settings to tune after installation
https://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/
How to connect to remote mysql server. Grant privileges
GRANT ALL PRIVILEGES ON *.* TO 'root'@'web.webhost.net' IDENTIFIED BY 'root-password-here';