处于安全考虑,数据库本不建议随便开启远程访问权限!!
本文出于开发方便考虑!
1.通过控制台登录 linux 的mysql;
2.use mysql;
会提示:Database changed;
3. SELECT User, Password, Host FROM user;
会出现(或许多两条)
+------+----------+-----------+ | User | Password | Host | +------+----------+-----------+ | root | | localhost | +------+----------+-----------+ 1 row in set (0.00 sec)
4. 下面我们另外添加一个新的 root 用户, 密码为空, 只允许 192.168.1.100 连接
(@'192.168.1.100'可以替换为@‘%’就可任意ip访问)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.100' IDENTIFIED BY '' WITH GRANT OPTION;
5.可以相应更改对应的密码 或者 host;
UPDATE user SET password=password('123456') WHERE User='root' AND Host='%' LIMIT 1;
UPDATE user SET host ='192.168.1.100' WHERE User='root' AND password= '123456' LIMIT 1;
6.输入这个才生效!
flush privileges;