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.
Now, you can access your database via phpMyAdmin.
How to manage my MySQL databases?
You can also backup and restore your database via phpMyAdmin.
phpMyAdmin: Backup MySQL database
phpMyAdmin: Restore MySQL database