Creating new user in MySQL and grant access to connect from any host

[anil.kumar]

You need to create user using '%' for this.


CREATE USER 'user_name'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;