Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

php mysql access host

I have several php accounts in a reseller package.  I am trying to move some code from one machine to another.  I believe that I need to do something with an access host to allow my code on the new server to access the database on the old one.  What should I do?  I tried adding an access host, but I am not sure what I am doing.
0
jackjohnson44
Asked:
jackjohnson44
  • 2
1 Solution
 
parparovCommented:
Your mysql server has to grant privileges for the queries to the new host with the code.
I am not sure what mysql management interface you're using, so I am unsure what specific advice to give you.
0
 
jackjohnson44Author Commented:
What do I use as a host name?  Do I just ping the server and use it's ip?  Is there a php script that I can run to get info?  I don't use a mysql management tool.  I am just running php code against it.
0
 
parparovCommented:
you use the name of server running the php script as the mysql server sees it.
Can you ssh between from php server to mysql server?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now