Create new MySQL database and user

Please follow the steps below to create New User MySQL:

1. Login to your hosting control panel (EG. http://yourdomain.com/cpanel)
2. Click the MySQL Database icon under the "Database" section.
3. Under "Create New Database",

New Database: [FILL IN THE NAME OF THE DATABASE]

4. Click Create Database. to create the database, next is to create the database user.
5. At the section "MySQL User", under "Add New User" fill in the following.

Usename: [ENTER USERNAME]
Password: [PLEASE USE A STRONG PASSWORD]
Password (Again): [RE-ENTER THE PASSWORD AGAIN]

6. Click Create User.
7. Next to associate the user with the database.
8. At the section "Add User To Database", select the "User" and "Database" then click the Add button.
9. Next tick the checkbox "All Privileges" and click Make Changes to complete the steps.
  • 3 Users Found This Useful
Was this answer helpful?