只需将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分钟通话, 中国电信官方发货