How to create MySQL databases with SiteWorx
Creating databases and users
If you are not the administrator, your SiteWorx user account must have the appropriate permissions to execute the below procedure. Contact your administrator and refer to How to add secondary users to your SiteWorx account for more information.
After creating your database, you may perform administrative functions by launching phpMyAdmin from the SiteWorx control panel.
Log in to your SiteWorx account.
If you do not know your password, click Forgot your password on the login page.
From the SiteWorx main menu, click Hosting Features > MySQL > Databases.
In the Database Name field, type the name of the new database. Do not use spaces or special characters, although you may use “_” to indicate a space, if necessary.
Click the Create User check box.
The menu will expand, allowing you to configure login credentials and assign permissions.
- If successful, the new database will appear in the Existing Databases section.
SiteWorx automatically prefixes your assigned database name with the first eight characters of your domain name, followed by an underscore.
When specifying database information for other applications, you must use this entire name.
If you want to create additional users for a database, refer to How to create MySQL database user accounts in SiteWorx.
MySQL database user permissions
The following table defines the available permissions that can be applied to a specific MySQL Database user account.
| User Permissions | Operations 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 or remove existing databases and tables. If this permission is enabled, the user can drop the database storing the MySQL access privileges for a user. |
| Create Temporary Table | Create temporary tables. |
| Create Routine | Create stored routines, procedures, and functions. |
| Update | Update database table rows and data. |
| References | Not currently in use. |
| Lock Tables | Lock tables in the database. |
| Alter Routine | Modify or alter stored routines. |
| Delete | Delete data and rows in database tables |
| Index | Create or remove indexes. |
| Create View | Create a new view. |
| Execute | Execute stored routines, procedures, and functions. |