mysql开启远程连接代码

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;