1.使用命令mysql -uroot -p密碼 進(jìn)入到數(shù)據(jù)庫(kù)中,執(zhí)行下面命令

USE mysql;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '數(shù)據(jù)庫(kù)密碼' WITH GRANT OPTION;

flush privileges;
2.防火墻中添加3306端口到防火墻例外后即可