1、一：windows环境 1、改表法。既然你的帐号不允许从远程登陆，只能在服务器上通过路径或桌面快捷键进入。登入mysql后，更改 “mysql” 数据库里的 “user” 表里的 “host” 项，从”localhost”改成”%”mysql -u root -pvmwaremysql>use mysql;mysql>update user set host = ‘%’ where user = ‘root’;mysql>select host, user from user;
3、二：linux类环境1.修改/etc/mysql/my.conf,修改bind-address,指定为本机实际IP地址,你的my.con修改完大概是如下[mysqld]## * Basic Settings#default-character-set=utf8default-storage-engine=INNODBbind-address = 192.168.1.16user = mysqlpid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.sockport = 3306basedir = /usrdatadir = /var/lib/mysqltmpdir = /tmplanguage = /usr/share/mysql/englishskip-external-locking
5、注意事项当出现本地连接不能用的时候，请查看mysql的user表；service mysqld stop //停止服务mysqld_safe --user=mysql --skip-grant-tables --skip-networking &mysql -u root mysqlselect host,user from user;如果host中有localhost 就直接删了吧。mysql登陆的时候会先匹配localhost，然后才是％
