-
GRANT ALL PRIVILEGES ON *.* TO 'test'@'192.168.16.138' IDENTIFIED BY '123456' WITH GRANT OPTION;
-
-
FLUSH PRIVILEGES;
-- mysql8*
CREATE USER 'user'@'192.168.1.106' IDENTIFIED by '123456';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.106' WITH GRANT OPTION;
FLUSH PRIVILEGES;