Solved

php mysql access host

Posted on 2011-09-26
3
180 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
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

If your site has a few sections that need to be secure when data is transmitted between the server and local computer, such as a /order/ section for ordering or /customer/ which contains customer data, etc it would of course be recommended to secure…
Creating and Managing Databases with phpMyAdmin in cPanel.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

919 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now