Use the following steps to create a new database user and assign the necessary privileges for your site:
- Log in to phpMyAdmin as a root user.
- Click on the User accounts tab in the top menu to get a screen similar to the following:
- Click the Add user account link to get a screen similar to the following:
- Add a User name and Password for the new user.
- Go to the Global privileges section, as shown in the following screenshot:
- Select all the options in the Data section.
- Select CREATE, ALTER, and DROP from the Structure ...