方法一：修改MySQL自带的“mysql”数据库中的“USER”表

USE  mysql;

UPDATE USER SET HOST='%' WHERE USER='root';

SELECT * FROM USER;

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJUAAAAYCAIAAAB87igeAAABeElEQVRoge2Zz2qDQBCH52H7YD7EHkoIgRBSyUaNGkWxT9CbB+/2YCtTjTh11f3DfPwIghLGfLvZXQbKInkjUBYJTl3Xnue1bfvlHEIIi94LqvJJ8VeVTxz2ZwjwWeULwv4MAeqlsD8TAE8BwehGyV/rIkII3SX8A9X/z8Y5On+6q6ACt4/3BcH+AODnu34vrMYyf9I/UM4P0j/g9P46Z/jTdtT97fk7wP12pPi73444Y39uyGus8xfKU2doaoXs7obyhOP8/OtH5GBojkfqywd2G9AQBWeKvyg44wzWP/y2OxS9Kf38e6lq9qLZef7F4YXiLw4vOIP9p6v+BrdM9Jc8rhR/yeOKM95/sr/xYzsAaexT/KWxj+P8+WFqDZtd/5q/C8rWQJZKir8slTh8fjcEyLOA4i/PAhz2ZwhQ5BHFX5FHOOzPEECx/667/vWxzJ9i/113/etjmT/F/rvu+tfHMn/cPxpgmT+V/u3m3WVmDpjadjJW8A3l5xjbmH9xSwAAAABJRU5ErkJggg==" alt="" />

方法二：采用授权的方式允许远程连接

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION ;