Contact
Site: US UK AU |

How to create MySQL database user accounts in SiteWorx

How to create MySQL database user accounts in SiteWorx

Overview
This article shows how Nexcess Classic (non-Cloud) clients can use SiteWorx to create a new MySQL database user account for an existing MySQL database.

What you need

  • A Nexcess Classic (non-Cloud) account. If you are a Nexcess Cloud client, instead contact our 24/7 Support Team by email or through the Client Portal for assistance.
  • Login information for your SiteWorx control panel account.
  • If you are a secondary user on another person's SiteWorx account, your user account must be have permission to create MySQL databases.

Notes

  • If you want a SiteWorx user other than yourself to manage databases through your SiteWorx account, you must first configure a secondary SiteWorx user account, assign the user to a database, and assign the appropriate permissions as directed below.

Procedure

The creation of a new MySQL user involves two steps:

  1. Create the user 
  2. Assign the user to a database

Create the user 

  1. From the SiteWorx main menu, click Hosting Options > MySQL > Users


    Figure 1. SiteWorx main menu; Hosting Options > MySQL > Users.

  2. In the MySQL Database User Management section, enter a username and password (Figure 2):


    Figure 2. MySQL Database User Management menu.

    1. For the password, either enter your own or click Generate to have SiteWorx create one for you. If you did not choose to generate a password, you must enter the password again in the Confirm Password field. 
    2. Note of the password; you will reference it when preparing applications to use this database.

  3. Click Add. The new user will appear in the Existing MySQL User section below. 


    Figure 3. Existing MySQL users section; new user.

  4. Proceed to the next section.

Attention: SiteWorx automatically prefixes the database user name with the first eight characters of your domain name. For example, if your domain name is example.com and the user name that you assigned to the account is jdoe, the name will appear as examplec_jdoe. If you are configuring an application that will be using one of your MySQL databases, specify the complete database and database user name.

Assign the user to a database

  1. In the SiteWorx main menu, select Hosting Options > MySQL > Databases (Figure 4).


    Figure 4. SiteWorx main menu; Hosting Options > MySQL > Databases

  2. In the Existing Databases section, locate the desired database and select Manage Users (Figure 5).


    Figure 5. MySQL Database Management page; Existing Databases section; Manage Users.

  3. From the User drop-down menu, select the appropriate user. 

    Assigning Permissions to a New MySQL User
    Figure 4. MySQL User Permissions section; user selection and permissions.

  4. By default, all permission check boxes are selected. To remove a permission, clear the corresponding check box. Refer to the Table 1 in the Permissions section below for more information.
  5. In the When Connecting From field, either leave it empty to allow the user to connect from any hostname, or specify the hostname the user must connect from (Figure 4).  
  6. Click Add (Figure 4).

Permissions

The following table defines the available permissions for application to a MySQL user. The order in which the permissions are listed reflects the order in which they are provided on the SiteWorx MySQL Database Management menu.

User PermissionOperations 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)

Table 1. Permission list and definitions.

 

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 add secondary users from your SiteWorx account
Added on Fri, Dec 14, 2018
How to use SiteWorx to install ExpressionEngine
Added on Mon, Jan 14, 2019
What is phpMyAdmin?
Added on Mon, Dec 17, 2018
What is SiteWorx?
Added on Tue, Dec 18, 2018
How to show running MySQL queries in SiteWorx
Added on Mon, Dec 17, 2018
How to delete MySQL databases in Nexcess Cloud
Added on Thu, Dec 20, 2018
How to view website statistics with SiteWorx
Added on Mon, Oct 1, 2018
How to change email account passwords in SiteWorx
Added on Wed, Dec 19, 2018
How to truncate MySQL tables from the CLI
Added on Mon, Dec 17, 2018
How to delete secondary users from your SiteWorx account
Added on Wed, Dec 12, 2018