允许用户远程登录:
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;
时间:2021-12-14 17:54:19
允许用户远程登录:
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;