{"id":211,"date":"2017-11-17T10:10:03","date_gmt":"2017-11-17T02:10:03","guid":{"rendered":"https:\/\/damogame.cn\/?p=211"},"modified":"2017-11-17T10:10:03","modified_gmt":"2017-11-17T02:10:03","slug":"linux%e4%b8%8b%e5%ae%89%e8%a3%85mysql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%8e%8b%e7%bc%a9%e5%8c%85%e6%96%b9%e5%bc%8f%e5%ae%89%e8%a3%85","status":"publish","type":"post","link":"https:\/\/i007.cc\/wordpress\/archives\/211","title":{"rendered":"Linux\u4e0b\u5b89\u88c5MySQL\u6570\u636e\u5e93(\u538b\u7f29\u5305\u65b9\u5f0f\u5b89\u88c5)"},"content":{"rendered":"
<\/div>\n
\n
\n

1\u3001\u8fd9\u91cc\u6211\u5c06Mysql\u5b89\u88c5\u5728\/usr\/local\/mysql\u76ee\u5f55\u91cc\u9762\uff0c\u4e5f\u53ef\u4ee5\u5b89\u88c5\u5728\u5176\u4ed6\u5730\u65b9;<\/p>\n

\n
mkdir \/usr\/local\/mysql<\/pre>\n<\/div>\n
2\u3001\u4e0b\u8f7dMySQL\u538b\u7f29\u5305<\/p>\n
\n
wget http:\/\/dev.MySQL.com\/get\/Downloads\/MySQL-5.7\/mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz \r\n\r\n\/\/ \u5982\u679c\u4e0a\u8fb9\u7684\u547d\u4ee4\u4e0d\u884c\u7684\u8bdd \u53ef\u4ee5\u4f7f\u7528\u4e0b\u8fb9\u7684\u547d\u4ee4\r\ncurl -O -L http:\/\/dev.MySQL.com\/get\/Downloads\/MySQL-5.7\/mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz<\/pre>\n
<\/pre>\n<\/div>\n
3\u3001\u89e3\u538b\u5e76\u590d\u5236<\/p>\n
\n
tar -xvf mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz\r\nmv mysql-5.7.11-Linux-glibc2.5-x86_64\/* \/usr\/local\/mysql\/<\/pre>\n<\/div>\n
4\u3001\u521b\u5efadata\u76ee\u5f55<\/p>\n
\n
mkdir \/usr\/local\/mysql\/data<\/pre>\n<\/div>\n
5\u3001\u521b\u5efamysql\u7528\u6237\u7ec4\u53ca\u5176\u7528\u6237<\/p>\n
\n
groupadd mysql\r\nuseradd -r -g mysql mysql<\/pre>\n<\/div>\n
6\u3001\u521d\u59cb\u5316\u6570\u636e<\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n
[root@localhost mysql] .\/bin\/mysql_install_db --user=mysql --basedir=\/usr\/local\/mysql\/ --datadir=\/usr\/local\/mysql\/data\/\r\n2016-01-20 02:47:35 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize\r\n2016-01-20 02:47:45 [WARNING] The bootstrap log isn't empty:\r\n2016-01-20 02:47:45 [WARNING] 2016-01-19T18:47:36.732678Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead\r\n2016-01-19T18:47:36.750527Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)\r\n2016-01-19T18:47:36.750560Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)<\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n<\/div>\n
7\u3001\u590d\u5236\u914d\u7f6e\u6587\u4ef6\u5230 \/etc\/my.cnf<\/p>\n
\n
cp -a .\/support-files\/my-default.cnf \/etc\/my.cnf (\u9009\u62e9y)<\/pre>\n<\/div>\n
8\u3001MySQL\u7684\u670d\u52a1\u811a\u672c\u653e\u5230\u7cfb\u7edf\u670d\u52a1\u4e2d<\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n
cp -a .\/support-files\/mysql.server \/etc\/init.d\/mysqld\r\n\u4fee\u6539my.cnf\u6587\u4ef6\r\n# These are commonly set, remove the # and set as required.\r\nbasedir = \/usr\/local\/mysql\r\ndatadir = \/usr\/local\/mysql\/data\r\nport = 3306\r\n# server_id = .....\r\nsocket = \/tmp\/mysql.sock\r\ncharacter-set-server = utf8\r\n# Remove leading # to set options mainly useful for reporting servers.\r\n# The server defaults are faster for transactions and fast SELECTs.\r\n# Adjust sizes as needed, experiment to find the optimal values.\r\n# join_buffer_size = 128M\r\n# sort_buffer_size = 2M\r\n# read_rnd_buffer_size = 2M<\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n<\/div>\n
9\u3001\u521b\u5efaIn<\/p>\n
\n
ln -s \/usr\/local\/mysql\/  \/usr\/bin\/<\/pre>\n<\/div>\n
10\u3001\u542f\u52a8\u670d\u52a1<\/p>\n
\n
service mysqld start<\/pre>\n<\/div>\n
11\u3001\u521d\u59cb\u5316\u5bc6\u7801<\/p>\n
mysql5.7\u4f1a\u751f\u6210\u4e00\u4e2a\u521d\u59cb\u5316\u5bc6\u7801\uff0c\u5728root\u4e2d.mysql_secret\u6587\u4ef6\u4e2d\u3002<\/p>\n
\n
[root@localhost ~]# cat \/root\/.mysql_secret\r\n# Password set for user 'root@localhost' at 2017-03-16 00:52:34 \r\nws;fmT7yh0CM<\/pre>\n<\/div>\n
12\u3001\u767b\u5f55\u5e76\u4fee\u6539\u5bc6\u7801<\/p>\n
\n
[root@localhost ~]# mysql -u root -p\r\n\r\nalter user root@localhost identified by 'tiger';\r\n\r\nflush privileges;<\/pre>\n<\/div>\n
13\u3001\u9000\u51fa\u91cd\u65b0\u767b\u5f55\uff0c\u5b8c\u6210<\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n
mysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| sys                |\r\n+--------------------+\r\n4 rows in set (0.11 sec)<\/pre>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
1\u3001\u8fd9\u91cc\u6211\u5c06Mysql\u5b89\u88c5\u5728\/usr\/l<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[],"tags":[117],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","tag-01-linux"],"_links":{"self":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":0,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"wp:attachment":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}