Table of Contents
Creating a MySQL Database
This article provides instructions on using the SiteWorx control panel to create a MySQL database, and, optionally, a user for the database 1).
Prerequisites
- An existing SiteWorx account.
- If you are a secondary user on another's hosting account (i.e., you are not the owner), your user account must be set up with permission to create MySQL databases.
Notes
- When assigning a name to a database, do not use spaces.
Instructions
- Log in to your SiteWorx account.
- On the SiteWorx main menu, click Hosting Options > MySQL > Databases.
- In the Database Name box, enter the name that you want to assign to the new database (do NOT use spaces; underscores are acceptable).
NOTE: SiteWorx will automatically prefix the database name with the first 8 characters of your domain name. For example, if your domain name is "domain.com" and you assigned "my_database" as the database name, the full name would be "domainco_my_database". Be sure to use the full name when entering database settings in your applications.- If you do not want to create a user account at this time, skip to Step 7.
- If you want to create a user account now, select the Create User check box, and continue with the following steps.
After selecting the Create User check box, the page automatically expands to show additional fields for creating the user login information, as well as check boxes for selecting the access permissions that you will assign (or not assign) to the user.
- Specify a username and password.
TIP: To have a "strong" password generated for you, click the Generate button. - In the MySQL User Permissions row, you will notice that all permissions check boxes are selected by default.
- To apply a particular permission to the user, leave the corresponding check box selected (✔).
- If you do NOT want to apply a particular permission to the user, click the check box to clear the check mark.
- In the When Connecting From field box, you can specify the hostname from which the user must connect to the database; or, if you want to allow ALL hostnames, leave this field with the default, "%" (percent) symbol.
- To finish creating the MySQL database, click the Add button.
User Permissions
The following table defines each of the available permissions that can be applied to a specific MySQL Database user account.
NOTE: The order in which the permissions are listed reflects the order that they are provided on the SiteWorx MySQL Database Management page.
| User Permission | Operation(s) Allowed |
|---|---|
| Select | Select rows from tables in the database |
| Create | Create new databases or tables |
| Alter | Alter the table structure |
| Show View | Show views |
| Insert | Insert rows into tables |
| Drop | Drop (remove) existing databases and tables. If this permission is enabled for a user, the user will be able to drop the database in which the MySQL access privileges are stored. |
| Create Temporary Table | Create temporary tables |
| Create Routine | Create stored routines (procedures and functions) |
| Update | Update database table rows/data |
| References | Not currently used |
| Lock Tables | Lock tables in the database |
| Alter Routine | Modify (alter) stored routines |
| Delete | Delete data/rows in database tables |
| Index | Create or remove indexes |
| Create View | Create a new view |
| Execute | Execute stored routines (procedures and functions) |
External Resources
Related Articles
1)
Although it is optional to create a user account for the database now, you will need to create at least one "main" user account (with all permissions enabled) in order to fully set up or use the database.
