允许用户远程登录:
use mysql;update user set host = '%' where user = 'root';select host, user from user;flush privileges;
限制用户远程登录:
use mysql;update user set host = 'localhost' where user = 'root';select host, user from user;flush privileges;
时间:2019-11-26 16:23:56
允许用户远程登录:
use mysql;update user set host = '%' where user = 'root';select host, user from user;flush privileges;
限制用户远程登录:
use mysql;update user set host = 'localhost' where user = 'root';select host, user from user;flush privileges;