Jump to content
Larry Ullman's Book Forums

Search the Community

Showing results for tags 'mysql on remote server'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Single Editions
    • Modern Javascript: Develop and Design
    • The Yii Book
    • Effortless Flex 4 Development
    • Building a Web Site with Ajax: Visual QuickProject
    • Ruby: Visual QuickStart Guide
    • C++ Programming: Visual QuickStart Guide
    • C Programming: Visual QuickStart Guide
    • Adobe AIR: Visual QuickPro Guide
  • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (5th Edition)
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition)
    • PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide (3rd Edition)
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (2nd Edition)
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (1st Edition)
  • PHP for the Web: Visual QuickStart Guide
    • PHP for the Web: Visual QuickStart Guide (5th Edition)
    • PHP for the Web: Visual QuickStart Guide (4th Edition)
    • PHP for the Web: Visual QuickStart Guide (3rd Edition)
    • PHP for the World Wide Web: Visual QuickStart Guide (2nd Edition)
    • PHP for the World Wide Web: Visual QuickStart Guide (1st Edition)
  • Effortless E-commerce with PHP and MySQL
    • Effortless E-Commerce with PHP and MySQL (2nd Edition)
    • Effortless E-Commerce with PHP and MySQL
  • PHP Advanced: Visual QuickPro Guide
    • PHP Advanced and Object-Oriented Programming: Visual QuickPro Guide (3rd Edition)
    • PHP 5 Advanced: Visual QuickPro Guide (2nd Edition)
    • PHP Advanced: Visual QuickPro Guide
  • MySQL: Visual QuickStart Guide
    • MySQL: Visual QuickStart Guide (2nd Edition)
    • MySQL: Visual QuickStart Guide (1st Edition)
  • Other
    • Announcements
    • Newsletter, Blog, and Other Topics
    • Forum Issues
    • Social

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Found 1 result

  1. Hi everyone, I refer to my message in my other post some time ago: "Currently I am playing with accessing database of a remote database server from another website - so far things are in progress! (It was a complicated process in the beginning - I will share my experience sometime when my time is more flexible. Reference in book: Page 351, Tips item #2.)" Page 351, Tips item #2 in Larry's book says: The localhost value is used as the hose name when both the PHP script and the MySQL database reside on the same computer. You can use PHP to connect to a MySQL database running on a remote server by changing the host name in the PHP script and creating the proper permissions in MySQL. Note that in fact "and creating the proper permissions in MySQL" is a critical part in a setup process - and the permissions have to be obtained from the server host of the remote MySQL database. In my case, I have accounts of two sites that are hosted by two different companies. I wanted to set up a database on one site but wanted it to be accessible from scripts on both sites. Doing whatever modifications with the scripts on the site that does not hold the database will not make the scripts work with the remote database. Permissions must be obtained from the hosting company who hosts the database server before the scripts on the remote site to be workable. The "permission" is some configuration the host has to adjust on their server, and has nothing to do with the scripts (other than the access info as mentioned in the book). Hope this info is helpful to other 'newbies' like me Have a great day! Cofa 4/2/2012
×
×
  • Create New...