First, you go
here download the ODBC drivers, install them as said, then have your friend create a user account in his database editor.
Guide for HeidiSQL:
1. Click the highlighted button to bring up this dialog:
http://prntscr.com/1uoxl5
2. Click add:
http://prntscr.com/1uox8g
3. Check Global Privileges and set the password:
http://prntscr.com/1uoxsl
4. Get the information from your friend and modify the ini file accordingly.
Guide for Navicat:
1. Click User:
http://prntscr.com/1up0em
2. Click New User to get this dialog:
http://prntscr.com/1uoyvn
3. Set the username, host, password, and confirm the password:
http://prntscr.com/1uoyzl
4. Set the account's privileges:
http://prntscr.com/1uoz5w
5. Get the information from your friend and modify the ini file accoringly.