N06※群辉开启MariaDB远程登录权限

1> ssh登录到群辉

sudo -i
# 输入管理员密码

2> 切换到MariaDB安装目录

cd /volume1/@appstore/MariaDB10/usr/local/mariadb10/bin
# 输入数据库密码

3> sql 操作

use mysql;
update user set host = '%' where user = 'root';
grant all privileges on *.* to 'root'@'%' identified by 'password';  # 如果报错ERROR 1356 (HY000)
select host,user from user;  # 查看是否设置成功

4> 刷新权限

FLUSH PRIVILEGES;

5> 开启某个ip对数据库的访问权限

use mysql;
grant all privileges on `database1`.* to 'user1'@'192.168.1.100' identified by 'password1' WITH GRANT OPTION;
FLUSH PRIVILEGES;