S I T E  S E C T I O N S

Home
Sales
Dedicated Servers
Reseller Hosting
Virtual Private Server
Web Hosting
Support
articles
Site Design Quote
Privacy

S E C T I O N S

cpanel demo
Nameserver demo
WHM demo
Hosting Manual
Getting Started
Agora Shopping Cart
Anonymous ftp
Backup Manager
CGI Setup
CGI Centre
MS Frontpage
Ftp Help
Change Password
File Manager
Form Mail
Email
Mail List
Mime Types
MySql
Network Tools
Path Information
PGP Email
PHP information
_Directory password
Search Submit
Secure Server
SSH Telnet
_Server Side Include
Stats Overview
URL Redirection
Java
Control Panel
FAQ
Web Resources
Internet Security Alerts

MySQL

The MySQL option in the Control Panel allows the setup of a MySQL  database on your site.  Once the database has been installed, there is  documentation available within the MySQL Option for managing the database.   This procedure shows you how to install MySQL and provides a basic overview  of the screens you can expect to see within this option. display

How To Install MySQL on Your Site:

.From the Control Panel, select the MySQL icon.  Select from the following  form options, to first add a Database then create a user , which you can then add as a data base User

                               Data Bases

User:

Db:

Db:

1

 

 

.                             

                                Users

User Name:

Password:

 

 


 2. Select the Add button.  A message appears indicating your  database has been created.


 Clicking on the   phpMyAdmin link will bring up the 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:

The left frame displays the names of the databases available to  you.

The right frame welcomes you to phpMyAdmin , which is the  name of the administrative tool you are now using to manage your MySQL  database.

The link Show MySQL runtime information displays the following  table of statistics about your database.

Note:

The image has been cropped for spacing purposes.  Scroll down for more  information.

The link Show MySQL system variables displays the following  table of statistics about your database.

Note:

The image has been cropped for spacing purposes.  Scroll down for more  information.

The Log Out link logs you out of the MySQL option.

The phpMyAdmin-Homepage link opens the phpMyAdmin homepage,  an excellent resource of information related to the use of phpMyAdmin application.

Setting Up MySQL Databases

When you initially install MySQL on your site, you essentially  create a blank database.   In order to work on your database, you must add  tables to it.

How To Add Tables to Your Database:

1. Single-click on the database name in the left frame of phpMyAdmin page.

2. 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.

3. Enter the appropriate information in the fields to describe  the data fields you are  creating.  For help, select the Documentation link.

4. 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.

5. 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 (as illustrated in the image above), 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  (appearing as blue text in the image above).  These  commands allow you to change or drop any field you choose and to perform  other actions.

 Underneath the Documentation link are tools for working with the  fields including Inserting data into the fields.

 Other tools used for working with your database are available  from this page.  (Note:  not  all appear in the image above.)  Be sure to  scroll down to see all possible options.  Use the Documentation links for more information.

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.

The query tool (shown above) allows for complex queries against  your database.

 

[Home] [Web Hosting] [Reseller Hosting] [Virtual Private Server] [Dedicated Servers] [Sales] [Support]

Please contact our Webmaster with questions or comments.                          
©Copyright 2000 Arachno Net  All rights reserved.