Knowledgebase

Manage Database Users  Print this Article

Overview

This interface allows server administrators to retrieve a list of database users, each users database, and which account owns each database user. The server administrator can use this interface to rename database users.

Database users

This interface provides a table of all of the database users on the server.

Click each column heading to sort the list by that column. Search for a particular user with the Search text box.

Rename a database user

To rename a database user, perform the following steps:

  1. Click the pencil icon in the row that corresponds to the database user.

  2. Enter the new name for the database user in the Rename to text box.

    Important:

    To learn more about database username limits, see below:

     
    MySQL 5.6

    MySQL version 5.6 limits the database username to 16 characters. The server uses the first nine characters of this limit for the database prefix. The database prefix uses the cPanel account’s username and an underscore (_). The server only applies the first eight characters of the cPanel account’s username.

    For example:

    • db_ database prefix allows MySQL usernames of up to 13 characters.
    • An example_ database prefix allows MySQL usernames of up to eight characters.
     
    MySQL 5.7 and later

    MySQL versions 5.7 and later limit the database username to 32 characters. The server uses the first nine characters of this limit for the database prefix. The database prefix uses the cPanel account’s username and an underscore (_). The server only applies the first eight characters of the cPanel account’s username.

    For example:

    • db_ database prefix allows MySQL usernames of up to 29 characters.
    • An example_ database prefix allows MySQL usernames of up to 24 characters.
     
    MariaDB

    MariaDB limits the database username to 47 characters. The server uses the first nine characters of this limit for the database prefix. The database prefix uses the cPanel account’s username and an underscore (_). The server only applies the first eight characters of the cPanel account’s username.

    For example:

    • db_ database prefix allows MariaDB usernames of up to 44 characters.
    • An example_ database prefix allows MariaDB usernames of up to 39 characters.

     

     

     

  3. Enter a new password for the user in the Set Password text box.

    Note:
    This step is optional.

     

  4. Click Submit to confirm that you wish to rename the database user.

    • To cancel the action, click Close.

Was this answer helpful?

Related Articles

Additional MySQL Access Hosts
Overview: This interface allows you to permit remote hosts (servers) to access MySQL® databases...
Change MySQL User Password
Overview: This interface allows you to change a database user’s password. Because this feature...
Configure PostgreSQL
Overview: This interface allows you to complete the PostgreSQL® installation process, create...
Database Map Tool
Overview: This feature allows server administrators to grant ownership of database objects...
Manage Databases
Overview: This interface allows you to list cPanel-managed databases on your server, each...