Hi @michaelwoosley:

I have successfully granted permissions to the example_user after following the instructions of step 6 in the tutorial How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu 20.04

The commands I have entered are the following:

1. Log in to the MySQL root account:

   sudo mysql
   

2. Create the example_user account:

   CREATE USER 'example_user'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
   

   Of course, the real password is something else rather than password.

3. Grant the permissions to the user:

   GRANT ALL ON example_database.* TO 'example_user'@'%';
   

4. Finally, exit MySQL:

   exit
   

Make sure you did not miss any commands above. You can try to grant the permissions to the user again by following the above commands but skip the 2nd command.