{"id":279,"date":"2016-12-11T20:40:33","date_gmt":"2016-12-11T12:40:33","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=279"},"modified":"2016-12-11T20:40:33","modified_gmt":"2016-12-11T12:40:33","slug":"mysql5-7-10%e9%85%8d%e7%bd%ae%e5%92%8c%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=279","title":{"rendered":"MySQL5.7.10\u914d\u7f6e\u548c\u4f7f\u7528"},"content":{"rendered":"

\u524d\u4e24\u5929\u641emybatis\u548cspringmvc\u7684\u7ed3\u5408\uff0c\u641e\u4e86\u534a\u5929\u9879\u76ee\u5c31\u662f\u8dd1\u4e0d\u8d77\u6765\uff0c\u7531\u4e8e\u90fd\u6ca1\u6709\u63a5\u89e6\u8fc7\uff0c\u4e5f\u4e0d\u77e5\u9053\u539f\u56e0\u51fa\u5728\u54ea\u91cc\u3002\u4eca\u5929\u60f3\u5f7b\u5e95\u5b66\u4e60\u4e0bmybatis\uff0c\u4e8e\u662f\u5c31\u60f3\u4f7f\u7528MySQL\u3002\u4ece\u5b98\u7f51\u4e0a\u4e0b\u4e86\uff0cMySQL-5.7.10\u514d\u5b89\u88c5\u7248\uff0c\u672c\u6765\u4ee5\u4e3a\u53ea\u5965\u7b80\u5355\u914d\u7f6e\u4e0b\u5c31\u597d\u7684\uff0c\u786c\u662f\u82b1\u4e86\u4e24\u4e2a\u5c0f\u65f6\uff0c\u6c57\u3002\u3002\u3002\u3002<\/p>\n

1\u3001\u4e0b\u8f7dMySQL\u89e3\u538bD:\\mysql-5.7.10-winx64<\/p>\n

2\u3001\u5728MySQL\u76ee\u5f55\u4e0b\u65b0\u5efa\u4e00\u4e2amy.ini\u6587\u4ef6\uff0c\u5c06\u4e0b\u5217\u5185\u5bb9\u590d\u5236\u8fc7\u53bb\uff1a<\/p>\n

 <\/p>\n

\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n<\/td>\n
\n
\n
[mysql]<\/code><\/div>\n
# \u8bbe\u7f6emysql\u5ba2\u6237\u7aef\u9ed8\u8ba4\u5b57\u7b26\u96c6<\/code><\/div>\n
default<\/code>-<\/code>character<\/code>-<\/code>set<\/code>=<\/code>utf8<\/code><\/div>\n
<\/div>\n
[mysqld]<\/code><\/div>\n
#skip_grant_tables\u00a0 \u8fd9\u4e2a\u5148\u4e0d\u8981\uff0c\u8fd9\u662f\u5ffd\u7565\u6743\u9650\u3002<\/code><\/div>\n
#\u8bbe\u7f6e3306\u7aef\u53e3<\/code><\/div>\n
port <\/code>=<\/code> 3306<\/code><\/div>\n
# \u8bbe\u7f6emysql\u7684\u5b89\u88c5\u76ee\u5f55<\/code><\/div>\n
basedir<\/code>=<\/code>D:\\mysql<\/code>-<\/code>5.7<\/code>.<\/code>10<\/code>-<\/code>winx64<\/code><\/div>\n
# \u8bbe\u7f6emysql\u6570\u636e\u5e93\u7684\u6570\u636e\u7684\u5b58\u653e\u76ee\u5f55<\/code><\/div>\n
datadir<\/code>=<\/code>D:\\mysql<\/code>-<\/code>5.7<\/code>.<\/code>10<\/code>-<\/code>winx64\\data<\/code><\/div>\n
# \u5141\u8bb8\u6700\u5927\u8fde\u63a5\u6570<\/code><\/div>\n
max_connections<\/code>=<\/code>200<\/code><\/div>\n
# \u670d\u52a1\u7aef\u4f7f\u7528\u7684\u5b57\u7b26\u96c6\u9ed8\u8ba4\u4e3a8\u6bd4\u7279\u7f16\u7801\u7684latin1\u5b57\u7b26\u96c6<\/code><\/div>\n
character<\/code>-<\/code>set<\/code>-<\/code>server<\/code>=<\/code>utf8<\/code><\/div>\n
# \u521b\u5efa\u65b0\u8868\u65f6\u5c06\u4f7f\u7528\u7684\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce<\/code><\/div>\n
default<\/code>-<\/code>storage<\/code>-<\/code>engine<\/code>=<\/code>INNODB<\/code><\/div>\n
sql_mode<\/code>=<\/code>NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

3\u3001\u4ee5\u7ba1\u7406\u5458\u8eab\u4efd\u6253\u5f00cmd\u8fdb\u5165MySQL\u7684bin\u76ee\u5f55\u4e0b\uff0c<\/p>\n

\u7b2c\u4e00\u79cd\u60c5\u51b5\uff1a\u8f93\u5165mysql -u root \u2013p\uff0c\u7a7a\u683c\u56de\u8f66\uff0c\u51fa\u73b0\u9519\u8bef\u3002\u6240\u4ee5\u4e0d\u8f93\u5bc6\u7801\u4e5f\u662f\u8fdb\u4e0d\u53bb\u7684\u3002<\/p>\n

\u7b2c\u4e8c\u79cd\u60c5\u51b5\uff1a\u8f93\u5165mysqladmin -u root password “newpass”\uff0c\u7a7a\u683c\u6216\u8005\u8f93\u5bc6\u7801\uff0c\u51fa\u73b0\u9519\u8bef\u3002<\/p>\n

\u9519\u8bef\uff1aERROR 1045 (28000): Access denied for user ”@’localhost’ (using password: NO)<\/p>\n

\u5ea6\u5a18\u53ef\u4ee5\u544a\u8bc9\u4f60\u51e0\u79cd\u89e3\u51b3\u65b9\u6848\uff0c\u4f46\u90fd\u65e0\u6548\u3002<\/p>\n

4\u3001\u5728\u4e0a\u9762\u7684my.ini\u4e2d\u52a0\u5165<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
<span style<\/code>=<\/code>\"font-family: 'Microsoft YaHei'; font-size: 14px;\"<\/code>>skip_grant_tables<<\/code>\/<\/code>span><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u5728\u4f7f\u7528mysql -u root \u2013p\u767b\u5f55\u6570\u636e\u5e93\uff0c\u4e0d\u8f93\u5bc6\u7801\u76f4\u63a5\u56de\u8f66\uff0c\u624d\u53ef\u4ee5\u8fdb\u5165\u6570\u636e\u5e93\u3002<\/p>\n

5\u3001\u4f7f\u7528\u7f51\u4e0a\u8bf4\u7684update set\u5747\u4e0d\u80fd\u4fee\u6539\u5bc6\u7801\u6210\u529f\uff0c\u56e0\u4e3aMySQL5.7\u7248\u672cuser\u8868\u4e2d\u6ca1\u6709password\u8fd9\u4e2a\u5b57\u6bb5\u4e86\uff0c\u53ef\u4ee5\u4f7f\u7528desc user\u67e5\u770b\u5177\u4f53\u7684\u5b57\u6bb5\u7ed3\u6784\u3002\u767e\u5ea6\u540e\u624d\u77e5\u9053\u5bc6\u7801\u5b57\u6bb5\u653e\u5728\u4e86autihentication_string\u4e2d\u3002\u6240\u4ee5update\uff0cset\u8981\uff1aUPDATE user SET \u00a0autihentication_string= PASSWORD(‘123456’) WHERE user = ‘root’;
\n\"670487-20151223202406546-20678085201\" \"670487-20151223202417452-12008605802\"<\/p>\n

6\u3001quit\uff0cnet stop mysql\uff0c\u56de\u5230ini\u6587\u4ef6\u4e2d\u5c06skip_grant_tables\u5220\u9664\u3002\u91cd\u65b0\u5f00\u542fMySQL\u3002\u518d\u4ee5root\u767b\u5f55\uff0c\u6570\u65e5\u521a\u624d\u8bbe\u7f6e\u7684\u5bc6\u7801\u5373\u53ef\u3002<\/p>\n

\u00a0\u5e38\u7528\u663e\u793a\u547d\u4ee4\uff1a<\/h2>\n

\u663e\u793a\u547d\u4ee4
\n1\u3001\u663e\u793a\u6570\u636e\u5e93\u5217\u8868\u3002
\nshow databases;
\n\u521a\u5f00\u59cb\u65f6\u624d\u4e24\u4e2a\u6570\u636e\u5e93\uff1amysql\u548ctest\u3002mysql\u5e93\u5f88\u91cd\u8981\u5b83\u91cc\u9762\u6709MYSQL\u7684\u7cfb\u7edf\u4fe1\u606f\uff0c\u6211\u4eec\u6539\u5bc6\u7801\u548c\u65b0\u589e\u7528\u6237\uff0c\u5b9e\u9645\u4e0a\u5c31\u662f\u7528\u8fd9\u4e2a\u5e93\u8fdb\u884c\u64cd\u4f5c\u3002
\n\"200806302204323553\"<\/p>\n

2\u3001\u663e\u793a\u5e93\u4e2d\u7684\u6570\u636e\u8868\uff1a
\nuse mysql\uff1b \uff0f\uff0f\u6253\u5f00\u5e93\uff0c\u5b66\u8fc7FOXBASE\u7684\u4e00\u5b9a\u4e0d\u4f1a\u964c\u751f\u5427
\nshow tables;
\n3\u3001\u663e\u793a\u6570\u636e\u8868\u7684\u7ed3\u6784\uff1a
\ndescribe \u8868\u540d;
\n4\u3001\u5efa\u5e93\uff1a
\ncreate database \u5e93\u540d;
\n5\u3001\u5efa\u8868\uff1a
\nuse \u5e93\u540d\uff1b
\ncreate table \u8868\u540d (\u5b57\u6bb5\u8bbe\u5b9a\u5217\u8868)\uff1b
\n6\u3001\u5220\u5e93\u548c\u5220\u8868:
\ndrop database \u5e93\u540d;
\ndrop table \u8868\u540d\uff1b
\n7\u3001\u5c06\u8868\u4e2d\u8bb0\u5f55\u6e05\u7a7a\uff1a
\ndelete from \u8868\u540d;
\n8\u3001\u663e\u793a\u8868\u4e2d\u7684\u8bb0\u5f55\uff1a
\nselect * from \u8868\u540d;<\/p>\n

\u4e09\u3001\u4e00\u4e2a\u5efa\u5e93\u548c\u5efa\u8868\u4ee5\u53ca\u63d2\u5165\u6570\u636e\u7684\u5b9e\u4f8b
\ndrop database if exists school; \/\/\u5982\u679c\u5b58\u5728SCHOOL\u5219\u5220\u9664
\ncreate database school; \/\/\u5efa\u7acb\u5e93SCHOOL
\nuse school; \/\/\u6253\u5f00\u5e93SCHOOL
\ncreate table teacher \/\/\u5efa\u7acb\u8868TEACHER
\n(
\nid int(3) auto_increment not null primary key,
\nname char(10) not null,
\naddress varchar(50) default ‘\u6df1\u5733’,
\nyear date
\n); \/\/\u5efa\u8868\u7ed3\u675f
\n\/\/\u4ee5\u4e0b\u4e3a\u63d2\u5165\u5b57\u6bb5
\ninsert into teacher values(”,’glchengang’,’\u6df1\u5733\u4e00\u4e2d’,’1976-10-10′);
\ninsert into teacher values(”,’jack’,’\u6df1\u5733\u4e00\u4e2d’,’1975-12-23′);<\/p>\n

\u6ce8\uff1a\u5728\u5efa\u8868\u4e2d<\/p>\n

\uff081\uff09\u5c06ID\u8bbe\u4e3a\u957f\u5ea6\u4e3a3\u7684\u6570\u5b57\u5b57\u6bb5:int(3)\u5e76\u8ba9\u5b83\u6bcf\u4e2a\u8bb0\u5f55\u81ea\u52a8\u52a0\u4e00:auto_increment\u5e76\u4e0d\u80fd\u4e3a\u7a7a:not null\u800c\u4e14\u8ba9\u4ed6\u6210\u4e3a\u4e3b\u5b57\u6bb5primary key<\/p>\n

\uff082\uff09\u5c06NAME\u8bbe\u4e3a\u957f\u5ea6\u4e3a10\u7684\u5b57\u7b26\u5b57\u6bb5<\/p>\n

\uff083\uff09\u5c06ADDRESS\u8bbe\u4e3a\u957f\u5ea650\u7684\u5b57\u7b26\u5b57\u6bb5\uff0c\u800c\u4e14\u7f3a\u7701\u503c\u4e3a\u6df1\u5733\u3002varchar\u548cchar\u6709\u4ec0\u4e48\u533a\u522b\u5462\uff0c\u53ea\u6709\u7b49\u4ee5\u540e\u7684\u6587\u7ae0\u518d\u8bf4\u4e86\u3002<\/p>\n

\uff084\uff09\u5c06YEAR\u8bbe\u4e3a\u65e5\u671f\u5b57\u6bb5\u3002<\/p>\n

\u539f\u6587\uff1ahttp:\/\/www.cnblogs.com\/silence-hust\/p\/5071180.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u524d\u4e24\u5929\u641emybatis\u548cspringmvc\u7684\u7ed3\u5408\uff0c\u641e\u4e86\u534a\u5929\u9879\u76ee\u5c31\u662f\u8dd1\u4e0d\u8d77\u6765\uff0c\u7531\u4e8e…
Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-279","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=279"}],"version-history":[{"count":2,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/279\/revisions"}],"predecessor-version":[{"id":284,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/279\/revisions\/284"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}