Database User Permissions

I think you are looking for this:

• https://forge.laravel.com/docs/1.0/resources/databases.html#creating-database-users

And since you have the root user, after connecting via a GUI client, you can simply edit the permissions of that user by executing some queries. An article to get you started:

• https://docs.digitalocean.com/products/databases/mysql/how-to/modify-user-privileges/