登录mysql后
MariaDB [(none)]> grant all privileges on *.* to 'root'@'%' identified by '【password】' with grant option; #password为mysql的root用户密码
MariaDB [(none)]> flush privileges; #刷新权限
然后防火墙开放3306端口
登录mysql后
MariaDB [(none)]> grant all privileges on *.* to 'root'@'%' identified by '【password】' with grant option; #password为mysql的root用户密码
MariaDB [(none)]> flush privileges; #刷新权限
然后防火墙开放3306端口