数据库远程连接:
//系统数据库
USE mysql;
//添加远程访问用户权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
//刷新
flush privileges;
//验证
select host,user from user;
;
数据库远程连接:
//系统数据库
USE mysql;
//添加远程访问用户权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
//刷新
flush privileges;
//验证
select host,user from user;
;