Mysql数据库不允许从远程登陆,只能在localhost (127.0.0.1)登录,这个时候只要在localhost的那台电脑,登入mysql后,更改“mysql” 数据库里的“user”表里的“host"项,从”localhost”改称”%”,具体命令如下:
改表法:
命令:
mysql -u root -pvmware
mysql>use mysql;
mysql>update user set host =%' where user ='root';
mysql>flush privileges;
mysql>select host,user from user