When mysql accesses the linux server locally, SQLSTATE [HY000] [1130] Host '2017. 0.0.1 & _ MySQL appears.

Solution: after reading it online, you can change the user table of the mysql database and add a data with the host value of %, but it still does not work. Later, log on to mysql directly and grant the access permission. Run [root @ iZ25p77kem7Z ~] GRANTALLPRIVILEGESON ** TO solution: After reading the solution online, you can change the user table of the mysql database and add a data with the host value of %. Later, log on to mysql directly and grant the access permission.

Run

[Root @ iZ25p77kem7Z ~] # Grant all privileges on *. * TO 'username' @ '%' identified by 'userpwd' with grant option;

You can.