How Nexcess clients on physical (non-cloud) servers can create a new MySQL database user account for a MySQL database.
As an alternative means of user creation, you can create the user during the creation of the database; see How to create MySQL databases with SiteWorx.
In the SiteWorx main menu, select Hosting Options > MySQL > Databases.
In the Existing Databases section, locate the desired database and select Manage Users.
From the User drop-down menu, select the appropriate user.
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.
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.
Click Add.
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 Permission | 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 (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) |
For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.
Our award-winning customer care team is here for you.
Contact Support