Expertise level: Easy
To create databases and its users, please use the following procedure:
- Log in to your cPanel Interface.
- Go to "Databases" section.
- Click on "MySQL Databases".
- Under "Create New Database" section, add the database name. Database name takes the form username_dbName.
- Click on "Create Database" button.
- Click on "Go Back" in order to return to previous page.
- Under "MySQL users", you can add new users and their passwords.
- Click "Create User".
- Click on "Go Back" in order to return to previous page.
- Under "Add User To Database" select the database and user from the drop-down menus.
- Click on "Add".
- Now you can give the necessary permissions to the user on the database by selecting the appropriate boxes.
- Click on "Make changes".
Check the relevant screen captures:
0 Comments