Contact
Site: US UK AU |

How to create MySQL databases and users with SiteWorx

How to create MySQL databases and users with SiteWorx

Overview
This article explains how to use SiteWorx to create a MySQL database and users for that database.

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 a secondary user to your SiteWorx account 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.

  1. Log in to your SiteWorx account.

  2. From the SiteWorx main menu, click Hosting Features > MySQL > Databases (Figure 1).


    Figure 1. SiteWorx main menu, Hosting Features > MySQL > Databases.

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

Figure 2. MySQL Database Management panel, Database Name field, and sample database name.

  1. Click the Create User check box (Figure 3).


    Figure 3. MySQL Database Management panel; Create User check box.

  1. The menu will expand, allowing you to configure login credentials and assign permissions (Figure 4).


    Figure 4. MySQL Database Management menu, login credential creation and permission selection.

    1. In the Username field, enter the desired username. You must use one word of no more than seven characters, though you may include a “_” to indicate a space, if desired.

    2. To choose the password, choose one of the following:

      • Create your own password by typing it into both the Password and Confirm Password fields. For security tips and general advice about password creation, refer to How to create a secure password.

      • Either enter a password or click Generate to have SiteWorx create one for you. 

    3. Assign permissions as desired. By default, all permissions are enabled; clear each check box to remove permissions as necessary.

    4. In the When Connecting From field, specify the hostname from which the user must connect to the database. If you are unsure, leave it blank.

    5. Click Add.

  1. If successful, the new database will appear in the Existing Databases section  (Figure 5).

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


      Figure 3. Existing Databases section; new sample database.

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

 

For 24-hour assistance any day of the year, contact our Support Team by email or through the Client Portal.

Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
 
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to view your bandwidth usage
Added on Wed, May 23, 2018
How to manage firewall whitelists in SiteWorx
Added on Wed, Nov 12, 2014
How to view website statistics with SiteWorx
Added on Mon, Oct 1, 2018
How to create a subdomain with SiteWorx
Added on Mon, Aug 5, 2013
What is phpMyAdmin?
Added on Fri, Sep 5, 2014
How to truncate MySQL tables
Added on Fri, Oct 30, 2015
How to show running MySQL queries
Added on Fri, Nov 13, 2015
How to configure DNS records in SiteWorx
Added on Tue, Jul 31, 2018
How to change permissions for MySQL users
Added on Mon, Jul 29, 2013
How to purchase standard SSL certificates
Added on Fri, Sep 14, 2018