|
Using the MySQL Database Manager
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.
Back to Control Panel Details
|
Account Control Panel
SITE SEARCH:
Control Panel 