Mysql 设置密码，IP访问权限

1.免密码登录

service mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &  //忘记密码，设置免密登录
# mysql -u root mysql
mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

2.设置权限

如修改root 设置:root host 183.xx. 只能这个外网IP可以访问

mysql> select user,host from user;
+---------------+----------------+
| user          | host           |
+---------------+----------------+
| root          | 183.62.178.193 |
| mysql.session | localhost      |
| mysql.sys     | localhost      |
| root          | localhost      |
+---------------+----------------+

设置可以任何主机IP访问: %

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '111111' WITH GRANT OPTION;
flush privileges;