These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
GRANT ALL PRIVILEGES ON . TO ‘myuser’@‘localhost’ WITH GRANT OPTION;
<br>
<br>For specified database: (mydatabase)
<br>
<br>GRANT ALL ON mydatabase TO ‘myuser’@‘localhost’;
We have an article on this: https://www.digitalocean.com/community/articles/how-to-create-a-new-user-and-grant-permissions-in-mysql
GRANT ALL PRIVILEGES ON . TO ‘myuser’@‘localhost’ WITH GRANT OPTION; <br> <br>For specified database: (mydatabase) <br> <br>GRANT ALL ON mydatabase TO ‘myuser’@‘localhost’;