is not allowed to connect to this MySQL server解决办法 问题解决方法: 首先使用update把mysql.user中的root的host从localhost修改成%: mysqlUPDATE?mysql.user?SET?Host='%'?WHERE?Host='localhost'?; mysql?GRANT?ALL?PRIVILEGES?ON?*.*?TO?root@"%"; m
is not allowed to connect to this MySQL server解决办法问题解决方法:
首先使用update把mysql.user中的root的host从localhost修改成%:
mysql>UPDATE?mysql.user?SET?Host='%'?WHERE?Host='localhost'?;
mysql>?GRANT?ALL?PRIVILEGES?ON?*.*?TO?root@"%";
mysql>;FLUSH?PRIVILEGES?;?