mysql auth

点击(此处)折叠或打开

1. GRANT ALL PRIVILEGES ON *.* TO 'test'@'192.168.16.138' IDENTIFIED BY '123456' WITH GRANT OPTION;
   
2. 
   
3. 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;