| <\/p>\n \u5728MySQL Qurey\u00a0\u00a0 Brower\u4e2d\u76f4\u63a5\u5bfc\u5165*.sql\u811a\u672c\uff0c\u662f\u4e0d\u80fd\u4e00\u6b21\u6267\u884c\u591a\u6761sql\u547d\u4ee4\u7684\uff0c\u5728mysql\u4e2d\u6267\u884csql\u6587\u4ef6\u7684\u547d\u4ee4\uff1a<\/p>\n mysql> source\u00a0\u00a0 d:\/myprogram\/database\/db.sql;<\/p>\n \u53e6\u9644mysql\u5e38\u7528\u547d\u4ee4\uff1a<\/p>\n \u4e00) \u8fde\u63a5MYSQL\uff1a<\/p>\n \u683c\u5f0f\uff1a mysql -h\u4e3b\u673a\u5730\u5740 -u\u7528\u6237\u540d \uff0dp\u7528\u6237\u5bc6\u7801<\/p>\n 1\u3001\u4f8b1\uff1a\u8fde\u63a5\u5230\u672c\u673a\u4e0a\u7684MYSQL<\/p>\n \u9996\u5148\u5728\u6253\u5f00DOS\u7a97\u53e3\uff0c\u7136\u540e\u8fdb\u5165mysql\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684bin\u76ee\u5f55\u4e0b\uff0c\u4f8b\u5982\uff1a D:\/mysql\/bin\uff0c\u518d\u952e\u5165\u547d\u4ee4mysql -uroot -p\uff0c\u56de\u8f66\u540e\u63d0\u793a\u4f60\u8f93\u5bc6\u7801\uff0c\u5982\u679c\u521a\u5b89\u88c5\u597dMYSQL\uff0c\u8d85\u7ea7\u7528\u6237root\u662f\u6ca1\u6709\u5bc6\u7801\u7684\uff0c\u6545\u76f4\u63a5\u56de\u8f66\u5373\u53ef\u8fdb\u5165\u5230MYSQL\u4e2d\u4e86\uff0cMYSQL\u7684\u63d0\u793a\u7b26\u662f\uff1amysql><\/p>\n 2\u3001\u4f8b2\uff1a\u8fde\u63a5\u5230\u8fdc\u7a0b\u4e3b\u673a\u4e0a\u7684MYSQL (\u8fdc\u7a0b\uff1aIP\u5730\u5740)<\/p>\n \u5047\u8bbe\u8fdc\u7a0b\u4e3b\u673a\u7684IP\u4e3a\uff1a10.0.0.1\uff0c\u7528\u6237\u540d\u4e3aroot,\u5bc6\u7801\u4e3a123\u3002\u5219\u952e\u5165\u4ee5\u4e0b\u547d\u4ee4\uff1a<\/p>\n mysql -h10.0.0.1 -uroot -p123<\/p>\n \uff08\u6ce8\uff1au\u4e0eroot\u53ef\u4ee5\u4e0d\u7528\u52a0\u7a7a\u683c\uff0c\u5176\u5b83\u4e5f\u4e00\u6837\uff09<\/p>\n 3\u3001\u9000\u51faMYSQL\u547d\u4ee4<\/p>\n exit \uff08\u56de\u8f66\uff09<\/p>\n (\u4e8c) \u4fee\u6539\u5bc6\u7801\uff1a<\/p>\n \u683c\u5f0f\uff1amysqladmin -u\u7528\u6237\u540d -p\u65e7\u5bc6\u7801 password \u65b0\u5bc6\u7801<\/p>\n 1\u3001\u4f8b1\uff1a\u7ed9root\u52a0\u4e2a\u5bc6\u7801123\u3002\u9996\u5148\u5728DOS\u4e0b\u8fdb\u5165\u76ee\u5f55C:\/mysql\/bin\uff0c\u7136\u540e\u952e\u5165\u4ee5\u4e0b\u547d\u4ee4\uff1a<\/p>\n mysqladmin -uroot -password 123<\/p>\n \u6ce8\uff1a\u56e0\u4e3a\u5f00\u59cb\u65f6root\u6ca1\u6709\u5bc6\u7801\uff0c\u6240\u4ee5-p\u65e7\u5bc6\u7801\u4e00\u9879\u5c31\u53ef\u4ee5\u7701\u7565\u4e86\u3002<\/p>\n 2\u3001\u4f8b2\uff1a\u518d\u5c06root\u7684\u5bc6\u7801\u6539\u4e3a456<\/p>\n mysqladmin -uroot -pab12 password 456<\/p>\n (\u4e09) \u589e\u52a0\u65b0\u7528\u6237\uff1a\uff08\u6ce8\u610f\uff1a\u548c\u4e0a\u9762\u4e0d\u540c\uff0c\u4e0b\u9762\u7684\u56e0\u4e3a\u662fMYSQL\u73af\u5883\u4e2d\u7684\u547d\u4ee4\uff0c\u6240\u4ee5\u540e\u9762\u90fd\u5e26\u4e00\u4e2a\u5206\u53f7\u4f5c\u4e3a\u547d\u4ee4\u7ed3\u675f\u7b26\uff09<\/p>\n \u683c\u5f0f\uff1agrant select on \u6570\u636e\u5e93.* to \u7528\u6237\u540d@\u767b\u5f55\u4e3b\u673a identified by “\u5bc6\u7801”<\/p>\n \u4f8b1\u3001\u589e\u52a0\u4e00\u4e2a\u7528\u6237test1\u5bc6\u7801\u4e3aabc\uff0c\u8ba9\u4ed6\u53ef\u4ee5\u5728\u4efb\u4f55\u4e3b\u673a\u4e0a\u767b\u5f55\uff0c\u5e76\u5bf9\u6240\u6709\u6570\u636e\u5e93\u6709\u67e5\u8be2\u3001\u63d2\u5165\u3001\u4fee\u6539\u3001\u5220\u9664\u7684\u6743\u9650\u3002\u9996\u5148\u7528\u4ee5root\u7528\u6237\u8fde\u5165MYSQL\uff0c\u7136\u540e\u952e\u5165\u4ee5\u4e0b\u547d\u4ee4\uff1a\u00a0\u00a0\u00a0\u00a0 grant select,insert,update,delete on *.* totest2@localhost<\/a>\u00a0identified by “abc”;<\/p>\n |