# linux 服务器新增用户
122.51.82.85 ALTER USER ‘root’@’%’ IDENTIFIED BY ‘Liaowei0512!’;
# linux 服务器防火墙(centos7)
systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl mask firewalld.service
# linux 服务器防火墙(ubuntu)
yum install iptables-services -y
systemctl enable iptables
systemctl start iptables
vim /etc/sysconfig/iptables
-A INPUT -p tcp -m state –state NEW -m tcp –dport 3306 -j ACCEPT
-A INPUT -p tcp -m state –state NEW -m tcp –dport 8002 -j ACCEPT
-A INPUT -p tcp -m state –state NEW -m tcp –dport 8003 -j ACCEPT
-A INPUT -p tcp -m state –state NEW -m tcp –dport 8004 -j ACCEPT
-A INPUT -p tcp -m state –state NEW -m tcp –dport 8888 -j ACCEPT
# mysql
systemctl enable mysqld.service
systemctl start mysqld.service
systemctl restart mysqld.service
update user set host=’%’ where user=’root’;
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’WITH GRANT OPTION;
# 刷新
FLUSH PRIVILEGES;
update user set plugin=’mysql_native_password’ where user=’root’;
# 忘记登录密码
skip-grant-tables
# mysql 8 后 ，需要修改配置
select @@session.sql_mode;
set @@session.sql_mode =’STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’
select @@global.sql_mode
set @@global.sql_mode =’STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’;