群晖 MaraiDB10,修改密码后出现Lost connection to MySQL server at ‘reading initial communication packet’, syst

用群晖MariaDB10 重置ROOT密码后,在Navicat中链接数据库会出现Lost connection to MySQL server at ‘reading initial communication packet’, syst错误

解决办法

登录ssh
cd /volume1/@appstore/MariaDB10/usr/local/mariadb10/bin
./mysql -u root -p

输入数据库密码

use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;

就可以顺利登录了!