Create MySQL User (Any Host) in Ubuntu

Tutorial Cara Create New User MySQL untuk user Local (localhost) dan user di Any Host :

MYSQL CREATE NEW USER

create user ‘alex’@’localhost’ identified by ‘alexlocal’;

Query OK, 0 rows affected (0.00 sec)

GRANT ACCESS USER

grant all privileges on *.* to ‘alex’@’localhost’ with grant option;

Query OK, 0 rows affected (0.00 sec)

MYSQL CREATE NEW USER ANY HOST

create user ‘alex’@’%’ identified by ‘ alexanyhost’;

Query OK, 0 rows affected (0.00 sec)

GRANT ACCESS USER ANY HOST

grant all privileges on *.* to ‘alex’@’%’ with grant option;

Query OK, 0 rows affected (0.00 sec)