SiteWorx's Database Management Facility provides an easy-to-use administration interface for common MySQL Management Tasks, including creation/deletion of databases and administration of database Users. In this tutorial, we will look at how such common tasks are performed.

The Database Management Facility is readily accessible by simply clicking on the Databases option in the left Control Panel Menu:

The result of doing such is that you will be brought to the main Database Management screen, similar to that illustrated below. Displayed on this screen are key statistics regarding your MySQL Database usage (i.e. number of databases used, and the total allowed, as well as number of users created, and the total allowed):

As illustrated below, there are two main sub-facilities within the SiteWorx Database Manager. The first, ("A," below,) allows you to manage MySQL Databases. The second option ("B," below,) enables you to create and modify individual MySQL User accounts. Both facilities can be accessed by clicking on their respective text links, as depicted below. The third option ("C," below,) labeled "PhpMyAdmin," when clicked, takes you to the PhpMyAdmin Database Management System. This final option is beyond the scope of this tutorial.

Managing MySQL Databases

We will begin assessing the management of actual MySQL Databases in SiteWorx by first creating a database for illustrative purposes. To do this, we click on any of the links marked "A," above, from the main Database Management screen (e.g., "Manage MySQL Databases."). We are subsequently taken to the MySQL Database Management sub-facility, similar to that depicted below:

Creating a New Database

We will continue by creating a demonstrative database called "Clients."

1. To accomplish this, we enter the name "Clients" into the Database Name input box of the Add a MySQL Database sub-window, as displayed below:

   

2. We continue by pressing the Add button:

   

3. SiteWorx will indicate our success, and we will see our new database in the listing of Existing Databases, along with its name and disk space usage:

   

Managing Users of an Existing Database

1. We will now continue by Managing the Users of our existing database. Our goal is to map a user to this database, so that it may be used. (All databases, prior to use, must have at least one user mapped to them.) To accomplish this, we first press the button Manage Users:

   

2. We are subsequently presented with the Database User Management Screen, similar to that depicted below:

   

3. There are three primary options that we can set. The first, User, is a drop-down list box that contains a listing of all existing MySQL Users on our system. In the example below, the appropriate user (healthyj_Karl) is already selected:

   

4. The next set of options involve the Database Permissions we wish to assign to our user. Database permissions are required for all users that will have access to your databases.

   

5. At least one user must have permissions on your database before it can be used. In most cases, you will wish to give a user full access with all permissions on your database. If you require multiple users for a database, you may wish to restrict each additional user, depending on what type of access they require. Following is a brief description of the permissions available to your database users:

   SELECT: allows use of SELECT statements (i.e. data can be queried)

   DELETE: allows use of DELETE statements (i.e. data can be deleted)

   REFERENCES: not currently used by MySQL but reserved for future use

   INSERT: allows use of INSERT statements (i.e. data can be inserted into tables)

   CREATE: allows use of CREATE statements (i.e. tables can be created)

   INDEX: allows the creation and deletion of indexes

   UPDATE: allows use of UPDATE statement (i.e. data may be altered within a table)

   DROP: allows use of DROP statement (i.e. tables may be deleted/"dropped")

   ALTER: allows use of ALTER statement (i.e. table structures may be changed/altered).

   (NOTE: The [check all] and [uncheck all] options provide a shortcut to checking individual permission checkboxes.)

6. The final setting, When Connecting From:, controls the user's access, only allowing them to utilize their permissions from a given IP address/hostname. In the majority of cases, this setting can be left at its default value:

   

7. In the example below, we have given Karl all permissions for our database, with the exception of ALTER:

   

8. We will continue by pressing the Add button to map Karl to our Clients database:

   

9. SiteWorx reports our success, and displays Karl as being mapped to our database with the permissions we selected:

   

10. If at any time we wish to unmap Karl from the database, we can simply Delete his mapping by returning to this screen, and pressing the Delete button next to his name. Similarly, should we wish to change his permissions, we can do so by pushing the Edit button adjacent to his name. The interface and functionality for this latter option is, for all intents and purposes, identical to that just described for adding a new user:

    

Managing MySQL Users

We will now turn our focus to the management of MySQL Users:

1. First, we must select the appropriate option from the main Database Management screen. To manage users, we click on one of the options labeled "B," below, such as "Manage MySQL Users":

   

2. Upon clicking on this option, we are taken to the MySQL User Management sub-facility, similar to that depicted below. Displayed are two sub-windows, one that allows us to add users (without any initial mappings to any databases), and one that displays all currently existing MySQL Users on our domain:

   

3. For the sake of example, we will add a user named "Ally," with password "catcity." First, we enter the appropriate data in the Add a MySQL User sub-window:

   

4. We continue by pressing the Add button:

   

5. SiteWorx confirms the addition, and Ally is now displayed in the list of MySQL Users for our domain:

   

6. We may modify Ally's password at any time by pressing the Edit button next to her name. Should we wish to delete Ally's account entirely, this may also be accomplished, simply by pressing the Delete button next to her name, and confirming the deletion when prompted:

   

Back to tutorials page