Mysql默认的远程连接端口为3306
先登录数据库,然后执行
RANT ALL PRIVILEGES ON *.* TO 'root'@'116.145.104.52' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
下面是命令开启
mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "你的密码";
mysql>flush privileges;
mysql>exit;