Datasheet

Book VIII
Chapter 1
Managing Your
Servers
893
Managing Data Remotely
Figure 1-18:
phpMy
Admin is
just like
the one on
your home
machine!
If you look carefully, you see that Freehostia is still using MySQL 4.
Therefore, not all SQL scripts in this book work correctly. The only signifi-
cant problem is views because this feature wasn’t included in MySQL 4. I
include a version of the buildHero4.sql script on the CD-ROM that elimi-
nates all references to views. Otherwise, the script is the same.
You can see from Figure 1-18 that phpMyAdmin is somewhat familiar if you
read Book VI. Often, public servers remove the Privileges section because
you aren’t logged in as root. Everything else is basically the same. See Book
VI for details on how to use phpMyAdmin to work with your databases.
Finding the MySQL server name
Throughout Book VI, I assume that the MySQL server is on the same physi-
cal machine as the Web server. This situation is common in XAMPP installa-
tions, but commercial servers often have separate servers for data. You may
have to dig through the documentation or find a Server Statistics section to
discover how your PHP programs should refer to your server.
53_9780470537558-bk08ch01.indd 89353_9780470537558-bk08ch01.indd 893 10/7/10 8:58 PM10/7/10 8:58 PM