D:\usr\local\mysql\bin>mysql -hlocalhost -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.0.26-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> quit
ByeD:\usr\local\mysql\bin>mysql -h192.168.123.110 -uroot
ERROR 1130: Host 'chenxiaotao' is not allowed to connect to this MySQL server
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.0.26-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> quit
ByeD:\usr\local\mysql\bin>mysql -h192.168.123.110 -uroot
ERROR 1130: Host 'chenxiaotao' is not allowed to connect to this MySQL server
先用localhost登录 授予root远程的权限
grant all on *.* to 'root'@'%'