To add a user to a database in CWP (CentOS Web Panel), navigate to SQL Services > MySQL Manager, click Add User, enter a username and strong password, and assign the necessary database privileges. Ensure you select the specific database from the dropdown menu to link the user to it, then save.

Step-by-Step Instructions Log in to CWP:

1. Access your CWP control panel (usually via port 2031 or 2030).
2. Access MySQL Manager: In the left-hand menu, go to SQL Services and click on MySQL Manager.
3. Add User: Click the Add User button.
4. Enter User Details:
   Username: Enter a unique username.
   Password: Create a strong password (you can use the built-in generator).
   Database: Select the database to which you want to add this user.
5. Assign Privileges: Select All Privileges or specific permissions, such as SELECT, INSERT, UPDATE, etc..
6. Save: Click the Save button to finalize.

To "Add a user", log into your control panel cPanel and click the "Manage MySQL" link. You will see a section of the page labeled "Users", and below it, two textboxes labeled "UserName:" and "Password:". Type your chosen username and password into the boxes and click the "Add User" button. You will see a message confirming that the new user has been added. Click the "Back" link to continue managing your MySQL database(s).

Add to Favourites
Print this Article