Grant all further rights to the new user, along with the right to grant new rights to other users: grant all on *.* to 'dbadmin'@'%' with grant option; Grant database creation and select privileges: ...

Create a new user with specific permissions Now that we’ve set up our MySQL server to allow remote connections, we need to create a new user and give it the correct permissions. To do this: ...