grant all privileges on *.* to ‘root‘@‘192.168.2.204‘ identified by ‘123456‘ with grant option;
flush privileges;
可直接用下面的，上面的执行之后，仅本机可以用ip进行链接，还是不能远程链接，下面的就ok了。
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION;
flush privileges;
原文：http://www.cnblogs.com/hcfan/p/5588331.html