The table will appear under the Tables tab. Create a new user by selecting “Users and Privileges” under the administration tab. In this example I will create a user with root privileges. Give the user a name. Set Authentication type to standard. You will not be able to connect using the other mode. Give the user a password and set the Limiting to host matching entry to %.