Jump to content

I Want To Just Use Mysql Fromt His Hosting Server


rupya
 Share

Recommended Posts

Hi will explain the scenario.

 

i have a 1 year accnt with ntchosting

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.

 

 

ntc hosting - phpbb forum and MT php scripts

total choice hosting - mysql server and datbase

 

Point the ntc hosting server php scripts to mysql database in total choice hosting .

Link to comment
Share on other sites

Hi Rupya,

 

Welcome to the family ;) :)

 

Sorry for the slow reply - but you have asked a very wide question ;)

 

Each script will need to be modified seperately.

 

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.

 

You will then need to go to each script and determine where it has the configuration for the mysql database.

 

There you will need to set the host, username and password to be the database information at the server here.

 

Perhaps it is best to go through each one of these seperately.

 

Alternatively - you can just move the accounts over to TCH and have them running on the same server ;)

Link to comment
Share on other sites

how to specify the mysql database server in total choice hosting to ntc hosting.

If you have a domain pointing to your account here, the server and port for mysql in your apps would be:

 

Server: ******

Port: 3306

 

If you don't have a domain pointing to your account, you can use the totalchoice name for your server:

 

Server: serverX.totalchoicehosting.com

Port: 3306

 

Where X is the number of your server (see your welcome message or your cPanel).

 

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".

 

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.

 

Hope that helps.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...