MySQL: creating a user that can connect from multiple hosts
Use this query to creating user account that can be connect from the localhost or from another server

CREATE USER 'bob'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;