07.02.2011, 13:59
It should be the same process as any MySQL server provided the webhost allows remote connections to the MySQL server. It's the same as connecting to your remote server, just create a database on it and then use the login details in the script with the mysql_connect function.
Although you should remember that connecting to an external MySQL server will probably be too slow for accounts and whatnot in SA-MP. Even when running threaded queries, the server won't hang but the players will have to wait for noticeably extended times for the queries to process. The latency between the external server containing the MySQL database and the server containing the SA-MP server is key to the situation, but even if they are very close, there will be a noticeable impact on performance.
Although you should remember that connecting to an external MySQL server will probably be too slow for accounts and whatnot in SA-MP. Even when running threaded queries, the server won't hang but the players will have to wait for noticeably extended times for the queries to process. The latency between the external server containing the MySQL database and the server containing the SA-MP server is key to the situation, but even if they are very close, there will be a noticeable impact on performance.