The new MySQL Database Manager utility has a number of new tools
to help you create, configure, and manage your databases. This
page provides an overview of techniques - for more detail select
the Database Manager User Guide, linked in the
top right hand of your main MySQL window. To get started, you
must create the first, default database, as follows:
From the Control Panel, select the MySQL icon.
Select the Add button. A message appears indicating your
database will be installed within approximately ten minutes. The
default name will be yourdomainname_com (net, org,
etc.). Your Control Panel username and password will be the
default used for your database. In the example shown here, the
domain name is "resellerdemo.com".
Main MySQL Screen
After your MySQL database has been installed, accessing the
MySQL icon on the Control Panel will open the database. Your
initial view of the database will appear similar to the
following:
This initial, default database should always be kept, even as
you add more databases. Never delete the default
database! As you create more databases, the default
name is used as a prefix for them. For example, the default db
for this account is resellerdemo_com. The next db for
this account might be called resellerdemo_com_sales , and
so on.
Next you have a number of options to configure and build your
database:
Manage Users and ODBC
Click on the database name from the screen above to
Manage the users and ODBC permissions. Users can be added with
special permissions and ODBC permissions granted to allow your
database to connect to web pages through scripting languages
like ASP or Cold Fusion. You'll also need ODBC configured to
convert an Access database to MySQL (see link below). For more
extensive details review the Database Manager User Guide, linked
in the top right hand of your main MySQL window.
 |
 |
Building your database - adding tables
- Single-click on the database name in
the left frame of phpMyAdmin page.
- Create a new table by entering the
table name in the Name field. Enter the number of data
fields which will be in the table in the Fields field.
Select the Go button. The Field setup page displays.
- Enter the appropriate information in
the fields to describe the data fields you are creating. For
help, check out the
phpMyAdmin documentation.
- Once all the information has been
added, select the Save button. The table page display,
listing statistics about the table you just created and
allowing a way of entering data into that table, or to
change the table itself if needed.
- Click on the Home link in the left
frame to return to the phpMyAdmin page or the yourdatabase
name link to return to the main page to administer your
database.
Working with Existing tables
After you have added tables to your database, subtle differences
to the main database page will appear on subsequent visits. More
options will be available to you, all of them as a result of the
fact that your database now has tables with which you can work.
For instance, if you single-click on the plus sign in the left
frame beside your database name, a listing of all of the tables
within your database appears.
Tables can be opened from this listing of tables. Single-click
on the table name in the left frame to open the table in the
right frame:
Notice that the fields and key of your table are listed along
with various commands. These commands allow you to change or
drop any field you choose and to perform other actions.
Run Query and Query by Example
From the main database page, you can run queries against your
database. When you query a database, you specify the criteria or
description of that query. Then you send that information to the
database and the database returns results from its data that
match the criteria you set. This query box should only be used
if you know how to write queries manually.
The Query By Example Link allows you to create a request for
information from your database using a form rather than typing
the query from scratch.
|