\u4ee5123.123.123.123 \u3001123.123.123.124\u4e24\u4e2aIP\u5730\u5740\u7684\u7528\u6237\u8bbf\u95eedb1\u4e3a\u4f8b\uff0c\u5206\u522b\u521b\u5efa\u7528\u6237\u540duser1\u3001user2<\/p>\n\n\n\n
1\u3001\u4e3a123.123.123.123\u4e0a\u521b\u5efa\u7528\u6237user1<\/p>\n\n\n\n
create user ‘user1’@’123.123.123.123’ IDENTIFIED BY ‘XXXXXXX’;<\/p>\n\n\n\n
grant select on db1.table1 to ‘user1’@’123.123.123.123’ ;<\/p>\n\n\n\n
2\u3001\u4e3a123.123.123.124\u4e0a\u521b\u5efa\u7528\u6237user2<\/p>\n\n\n\n
create user ‘user2’@’123.123.123.124’ IDENTIFIED BY ‘YYYYY’;<\/p>\n\n\n\n
grant select on db1.table1 to ‘user2’@’123.123.123.124’ ;<\/p>\n\n\n\n
<\/p>\n\n\n\n
\u8bf4\u660e\uff1a\u7528\u6237\u662f\u6309IP\u533a\u5206\u7684\uff0c\u4e0d\u540cIP\u7528\u6237\u540d\u53ef\u4ee5\u76f8\u540c<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4ee5123.123.123.123 \u3001123.123.123.124\u4e24\u4e2aIP\u5730\u5740\u7684\u7528\u6237\u8bbf\u95eedb1\u4e3a\u4f8b\uff0c\u5206\u522b\u521b\u5efa\u7528 … <\/p>\n