Access denied for user 'root'@'*.*.*.*' (using password: YES)
服務(wù)器IP沒有權(quán)利訪問,需要對mysql的IP進(jìn)行授權(quán)。
1,關(guān)掉mysql:service ?mysqld stop (第二次我試的時候,需要啟動mysql才能執(zhí)行下面的步驟)
2,?進(jìn)入mysql:mysql -u root -p
3,輸入mysql密碼:******;
4靖诗,輸入用戶:use mysql;
5,針對當(dāng)個ip授權(quán):mysql> ?GRANT ALL ON *.*?to root@'127.0.0.0' IDENTIFIED ?BY 'your-password'?WITH GRANT OPTION;
或者針對全部ip授權(quán):mysql> ?GRANT ALL PRIVILEGES ON *.* TO?'root'@'%'?IDENTIFIED ?BY 'your-password' WITH GRANT OPTION;
6谭确,刷新:mysql> FLUSH PRIVILEGES;
7,退出:mysql> exit
8票渠,重啟你的mysql數(shù)據(jù)庫 service mysqld start;
注意: 1逐哈、your-password 填寫你的服務(wù)器 mysql 的密碼