MySQL远程登陆

=安装mysql

https://www.cnblogs.com/yhongji/p/9783065.html

添加安全组

如果使用了阿里云的服务器，首先要修改安全组，允许MySQL默认的3306端口访问

具体请见：https://help.aliyun.com/document_detail/25471.html?spm=a2c4g.11186623.2.18.spVBK9

对远程访问授权

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'cloud17' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH   PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> exit;
Bye

Windows下执行远程登陆

mysql -h 47.106.110.18 -u root -p