只需将mysql.user中的Host列设为localhost，那么这个用户就只能在安装mysql的机器上登录了，INSERT INTO user VALUES("localhost","root","","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y");
#建立一个只能从本机登录的名为root的超级管理员，密码为空INSERT INTO user VALUES("192.168.0.%","Guest","","N","N","N","N","N","N","N","N","N","N","N","N","N","N");
#建立一个名为Guest的用户，他只能在局域网中登录，而且不能做任何事情，（你需要在db表中为它建立某一数据库的访问权限，例：
INSERT INTO db VALUES("localhost","catv","Guest","Y","N","N","N","N","N","N","N","N","N");
）
#建立一个只能从本机登录的名为root的超级管理员，密码为空INSERT INTO user VALUES("192.168.0.%","Guest","","N","N","N","N","N","N","N","N","N","N","N","N","N","N");
#建立一个名为Guest的用户，他只能在局域网中登录，而且不能做任何事情，（你需要在db表中为它建立某一数据库的访问权限，例：
INSERT INTO db VALUES("localhost","catv","Guest","Y","N","N","N","N","N","N","N","N","N");
）
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货