Datasheet

892
Managing Data Remotely
how this process works because it’s often slightly different from working
with the database on your local machine.
Creating your database
Often, a tool like the one shown in Figure 1-17 allows you to pick a defined
database or create a new one.
Figure 1-17:
You often
have to
create a
database
outside of
phpMy
Admin.
This database creation step happens because you don’t have root access
to MySQL. (If everybody had root access, chaos would ensue.) Instead,
you usually have an assigned username and database name enforced by the
server. On Freehostia, all database names begin with the username and an
underscore. To create a new database, you need to provide a database name
and a password. Usually, a MySQL user is created with the same name as the
database name.
After you create the database, you can select it to work with the data in
MySQL. Figure 1-18 shows the MySQL screen for my database on Freehostia.
53_9780470537558-bk08ch01.indd 89253_9780470537558-bk08ch01.indd 892 10/7/10 8:58 PM10/7/10 8:58 PM