mariadb数据库允许远程访问

select host,user,password from user; 查询数据库的用户信息

GRANT ALL PRIVILEGES ON . TO ‘root’@’%'IDENTIFIED BY ‘你的密码’ WITH GRANT OPTION;

root账号允许远程访问
grant all privileges on root.*to’root’@’%'identified by ‘123456’ with grant option;

flush privileges; 刷新权限