mysql配置允许内网机器连接:
GRANT ALL PRIVILEGES ON *.* TO 'myusername'@'192.168.1.%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
flush privileges;
192.168.1.% 指允许该网段的全部机器
修改用户密码:
use mysql;
update user set password=password("newpassword") where user="myuser";
flush privileges;