user managemet in mysql
You can use a name if the global variable skip_name_resolve is equal to false (otherwise it will not be resolved to an IP)
SHOW GLOBAL VARIABLES LIKE 'skip_name_resolve';
CREATE USER 'userName'@'%' IDENTIFIED WITH mysql_native_password BY 'secret';
CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password';
SELECT user, host FROM mysql.user;
user |host |
----------------|---------|
root |% |
crawler |localhost|
healthchecker |localhost|
mysql.infoschema|localhost|
mysql.session |localhost|
mysql.sys |localhost|
root |localhost|
UPDATE mysql.user SET host = '192.168.1.42' WHERE host = 'master';
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';