mysql通过命令行,添加root用户远程访问权限
show databases;
use mysql;
show tables;
select User,authentication_string,Host from user;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'222.222.222.222' IDENTIFIED BY '123456';
mysql通过命令行,添加root用户远程访问权限
show databases;
use mysql;
show tables;
select User,authentication_string,Host from user;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'222.222.222.222' IDENTIFIED BY '123456';