Setting up an ODBC between access and mySQL

I've been asked to set up an ODBC connection between an Access database and a mySQL database. I've never done this before and I'm having some difficulty connecting the two together.

My main issue appears to be the server name. I'm prompted by Access to insert the SQL server name along with my details. I host the database and have access to cPanel and phpMyAdmin but I can't seem to find an actual server name anywhere.

Where do I look for the server name or am I missing a vital step here somewhere? Why they've aske开发者_运维技巧d a front end dev to do this I wil never know :(

I don't think you can get the server IP from within mysql itself. This may help however

SELECT @@global.server_id

Which gives you the local server id