限制ip登录 update mysql.user set host='ip地址' where user='用户名'; 设置复杂密码 set password for root@localhost = password('root');