Just create an A record and create subdomain and put the ip there.
After created this how can I connect mySQL database? it is connected remotely?If you're using cpanel , here's what to do :
1. Add a subdomain under 'subdomains'
2. Go to 'advanced zone editor' and select your subdomain
3. Add an A record and in the 'address' field put the IP of your destination host
All done.