mysql 访问

mysql -uroot -ppassw0rd

 

select host,user,password from mysql.user;

 

update mysql.user set host='192.168.1.%' where host='localhost' and user='root';

 

flush privileges;