?
Solved

php mysql access host

Posted on 2011-09-26
3
Medium Priority
?
189 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 2000 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month16 days, 21 hours left to enroll

862 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