$ mysql -u root -p
# enter the following sql
CREATE USER domain@localhost; GRANT USAGE ON * . * TO  domain@localhost WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; CREATE DATABASE IF NOT EXISTS  domain; GRANT ALL PRIVILEGES ON  domain.* TO domain@localhost;
# then switch to the mysql db
# change password - use strongpasswordgenerator.com or similar, - ideally without symbols, easier to include in bash aliases
use mysql;
update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='domain';