mysql> create database db1;

mysql> create user 'dbuser1'@'localhost' identified by 'dbuser1password';

mysql> GRANT ALL PRIVILEGES ON db1.* TO 'dbuser1'@'localhost' WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'dbuser1'@'localhost'

mysql> GRANT ALL PRIVILEGES ON db1.* TO 'dbuser1'@'%' WITH GRANT OPTION;

mysql> flush privileges;