Hi will explain the scenario.<br /><br />i have a 1 year accnt with ntchosting <br />good bandwidtha and storage but the thing is the ntchosting are not providing any mysql storage more than 10 mb , so i got a accnt in total choice host6ing now so i want use just the mysql database from here and use the phpbbforum and movable type code in the other server point to total choise hosting ,how to specify the mysql database server in total choice hosting to ntc hosting.<br /><br /><br />ntc hosting - phpbb forum and MT php scripts<br />total choice hosting - mysql server and datbase<br /><br />Point the ntc hosting server php scripts to mysql database in total choice hosting .<!--content-->
Hi Rupya,<br /><br />Welcome to the family <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><br /><br />Sorry for the slow reply - but you have asked a very wide question <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /><br /><br />Each script will need to be modified seperately.<br /><br />First, I would log into your cpanel, and go into manage mysql where you can allow other hosts to access your database here. Add the IP address of the server hosting your scripts.<br /><br />You will then need to go to each script and determine where it has the configuration for the mysql database.<br /><br />There you will need to set the host, username and password to be the database information at the server here.<br /><br />Perhaps it is best to go through each one of these seperately.<br /><br />Alternatively - you can just move the accounts over to TCH and have them running on the same server <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="" border="0" alt="wink.gif" /><!--content-->
<!--QuoteBegin-rupya+Sep 14 2004, 02:07 PM--><div class='quotetop'>QUOTE(rupya @ Sep 14 2004, 02:07 PM)</div><div class='quotemain'><!--QuoteEBegin-->how to specify the mysql database server in total choice hosting to ntc hosting.<!--QuoteEnd--></div><!--QuoteEEnd--><br />If you have a domain pointing to your account here, the server and port for mysql in your apps would be:<br /><br />Server: <!--coloro:black--><span style="color:black"><!--/coloro-->******<!--colorc--></span><!--/colorc--><br />Port: 3306<br /><br />If you don't have a domain pointing to your account, you can use the totalchoice name for your server:<br /><br />Server: <!--coloro:black--><span style="color:black"><!--/coloro-->serverX.totalchoicehosting.com<!--colorc--></span><!--/colorc--><br />Port: 3306<br /><br />Where X is the number of your server (see your welcome message or your cPanel).<br /><br />The db name, username and password are what you setup in cPanel for each DB you create. Keep in mind that usernames and database names are preceeded by your account name, so if you cPanel login is "bob", your database would be something like "bob_mydbname" and your user "bob_myusername".<br /><br />Most of the apps you are using already will likely have the database server defined as "localhost". That's what you'll need to change.<br /><br />Hope that helps.<!--content-->
Hi Rupya,<br /><br />Welcome to the family <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><br /><br />Sorry for the slow reply - but you have asked a very wide question <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="" border="0" alt="wink.gif" /><br /><br />Each script will need to be modified seperately.<br /><br />First, I would log into your cpanel, and go into manage mysql where you can allow other hosts to access your database here. Add the IP address of the server hosting your scripts.<br /><br />You will then need to go to each script and determine where it has the configuration for the mysql database.<br /><br />There you will need to set the host, username and password to be the database information at the server here.<br /><br />Perhaps it is best to go through each one of these seperately.<br /><br />Alternatively - you can just move the accounts over to TCH and have them running on the same server <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="" border="0" alt="wink.gif" /><!--content--><!--QuoteBegin-rupya+Sep 14 2004, 02:07 PM--><div class='quotetop'>QUOTE(rupya @ Sep 14 2004, 02:07 PM)</div><div class='quotemain'><!--QuoteEBegin-->how to specify the mysql database server in total choice hosting to ntc hosting.<!--QuoteEnd--></div><!--QuoteEEnd--><br />If you have a domain pointing to your account here, the server and port for mysql in your apps would be:<br /><br />Server: <!--coloro:black--><span style="color:black"><!--/coloro-->******<!--colorc--></span><!--/colorc--><br />Port: 3306<br /><br />If you don't have a domain pointing to your account, you can use the totalchoice name for your server:<br /><br />Server: <!--coloro:black--><span style="color:black"><!--/coloro-->serverX.totalchoicehosting.com<!--colorc--></span><!--/colorc--><br />Port: 3306<br /><br />Where X is the number of your server (see your welcome message or your cPanel).<br /><br />The db name, username and password are what you setup in cPanel for each DB you create. Keep in mind that usernames and database names are preceeded by your account name, so if you cPanel login is "bob", your database would be something like "bob_mydbname" and your user "bob_myusername".<br /><br />Most of the apps you are using already will likely have the database server defined as "localhost". That's what you'll need to change.<br /><br />Hope that helps.<!--content-->