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.%';