配置指定IP连接

cd c:\program files\MySQL\MySQL Server 5.0\bin
>mysql -h localhost -u root -p
Enter password:  ---
Welcome to the MySQL monitor.....
.....

>grant all privileges on *.* to root@"%" identified by '111' with grant option;
>flush privileges;



>use mysql
Database changed
>select * from user;