mysql授权

mysql 对指定IP授权
GRANT ALL PRIVILEGES ON *.* TO 'user111'@'192.168.1.14'IDENTIFIED BY 'com.123' WITH GRANT OPTION; 
#对IP段授权
GRANT ALL PRIVILEGES ON *.* TO 'user111'@'192.168.%'IDENTIFIED BY 'com.123' WITH GRANT OPTION;

#对所有ip授权 GRANT ALL PRIVILEGES ON *.* TO 'user111'@'%'IDENTIFIED BY 'com.123' WITH GRANT OPTION;

#授权完之后刷新

FLUSH PRIVILEGES;

出现only_full_group_by问题

SET global sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
select @@global.sql_mode

mysql8授权

CREATE USER 'user11'@'192.168.%' IDENTIFIED BY 'pwd123';
grant all privileges on *.* to 'user1'@'192.168.%';