云服务器安装mysql
1.安装mysql
sudo apt-get install mysql-server
查看service状态
service mysql status
2.开放3306端口
3306端口默认不对外开放, 需要修改配置文件
/etc/mysql/mysql.conf.d/mysql.cnf
注释掉bind-address一行
3.修改权限表
mysql -urooot -p
use user;
select user, host from user;
update user set host = '%' where user = 'root';
flush privileges;
grant all privileges on *.* to username@"%";
重启mysql服务
service restart mysql
在腾讯云防火墙开放mysql3306端口