云服务器MySQL开启远程连接

1.连接MySQL
# mysql -uroot -proot
2.登录mysql数据库
MariaDB [(none)]> use mysql;
3.更改远程连接设置
MariaDB [mysql]>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234567' WITH GRANT OPTION;
   例如：指定访问demo数据库
MariaDB [mysql]>GRANT ALL PRIVILEGES ON demo.* TO 'root'@'%' IDENTIFIED BY '1234567' WITH GRANT OPTION;
4.生效修改的权限
MariaDB [mysql]> flush privileges;
5.查看修改结果
MariaDB [mysql]> select host,user from user;