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:
- Access your CWP control panel (usually via port 2031 or 2030).
- Access MySQL Manager: In the left-hand menu, go to SQL Services and click on MySQL Manager.
- Add User: Click the Add User button.
- 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. - Assign Privileges: Select All Privileges or specific permissions, such as SELECT, INSERT, UPDATE, etc..
- 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).