/******************************************************************** * ERROR 1130:host ' ... ′is not allowed to Connect to this MySQL server * Description: * Using remote login mysql, results can not log in, record the workaround. * 2016-9-22 Shenzhen Nanshan Ping Shan village Zengjianfeng ************************************************************* ******/First, reference documents:1. Error:1130-host ... isNot allowed to connect to ThisMySQL server open MySQL remote connection does not use localhost http://www.cnblogs.com/xyzdw/archive/2011/08/11/2135227.html 2. Turn on all methods of MySQL remote access http://superyjcqw.blog.163.com/blog/static/16105830520117111040436/Second, error:1. ERROR1130: Host ' ... isNot allowed to connect to ThisMySQL Server2. ERROR1062(23000): Duplicate Entry'%-root' forKey'PRIMARY'Third, the solution:1. Use MySQL; 2. Update userSethost= '% 'whereUser= ' root ' and host=' localhost '; 3.SelectHost, user fromUser
ERROR 1130:host ' ... ′is not allowed to connect to this MySQL server