Solved

php mysql access host

Posted on 2011-09-26
3
184 Views
Last Modified: 2012-05-12
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
Comment
Question by:jackjohnson44
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
parparov earned 500 total points
ID: 36707518
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
 

Author Comment

by:jackjohnson44
ID: 36711705
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
 
LVL 9

Expert Comment

by:parparov
ID: 36711924
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL Memory Keeps Increasing 4 92
How to fix Datetime in MySQL? 4 75
web server dns redirect 5 73
Formating field in mysql Advance formatting 1 54
It is possible to boost certain documents at query time in Solr. Query time boosting can be a powerful resource for finding the most relevant and "best" content. Of course the more information you index, the more fields you will be able to use for y…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question