Mysql取消SSH链接和恢复SSH链接

取消SSH链接
//键入密码,链接上mysql
 mysql -u root -p 

 

 USE MYSQL; 

 

 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;　　//%:表示任何一台机使用密码都可以登入,也可以传入IP指定某一台机有权限登入 

 flush privileges; 

 

//恢复SSH链接

 delete from user where host='%'; 

 

 

 flush privileges;