{"id":469,"date":"2020-12-10T12:36:39","date_gmt":"2020-12-10T04:36:39","guid":{"rendered":"http:\/\/log.tanxiaodian.com\/?p=469"},"modified":"2020-12-10T14:19:04","modified_gmt":"2020-12-10T06:19:04","slug":"%e7%bc%96%e8%af%91%e5%ae%89%e8%a3%85mysql","status":"publish","type":"post","link":"https:\/\/log.tanxiaodian.com\/?p=469","title":{"rendered":"\u7f16\u8bd1\u5b89\u88c5mysql"},"content":{"rendered":"\n

\u8f6c\u81ea https:\/\/www.cnblogs.com\/sky-cheng\/p\/10805541.html<\/a><\/p>\n\n\n\n

\u4e00\u3001\u4e0b\u8f7d\u6e90\u7801\u5305<\/h3>\n\n\n\n
\"\"
\u5728\u6b64\u4e0b\u8f7d\u5305https:\/\/downloads.mysql.com\/archives\/community\/<\/figcaption><\/figure>\n\n\n\n
mkdir  \/usr\/local\/src\/mysql-5.7.26-src\ncd \/usr\/local\/src\/mysql-5.7.26-src\nwget https:\/\/dev.mysql.com\/get\/Downloads\/MySQL-5.7\/mysql-5.7.26.tar.gz<\/pre>\n\n\n\n
\u4e8c\u3001\u6dfb\u52a0mysql\u7528\u6237\u548c\u7ec4<\/h3>\n\n\n\n
[root@node2 ~]# groupadd  mysql\n[root@node2 ~]# id myql\nid: myql: no such user\n[root@node2 ~]# useradd -d \/home\/myql -g mysql -m mysql\n[root@node2 ~]# id mysql\nuid=1000(mysql) gid=1000(mysql) \u7ec4=1000(mysql)<\/pre>\n\n\n\n
[root@node2 ~]# passwd mysql\n\u66f4\u6539\u7528\u6237 mysql \u7684\u5bc6\u7801 \u3002\n\u65b0\u7684 \u5bc6\u7801\uff1a\n\u91cd\u65b0\u8f93\u5165\u65b0\u7684 \u5bc6\u7801\uff1a\npasswd\uff1a\u6240\u6709\u7684\u8eab\u4efd\u9a8c\u8bc1\u4ee4\u724c\u5df2\u7ecf\u6210\u529f\u66f4\u65b0\u3002<\/pre>\n\n\n\n
\u4e09\u3001\u65b0\u5efa\u76f8\u5173\u76ee\u5f55\uff0c\u5e76\u8d4b\u6743\u9650\u7ed9mysql\u7528\u6237<\/h3>\n\n\n\n
[root@node2 home]# mkdir \/home\/mysql-5.7.26\n[root@node2 home]# mkdir \/home\/mysql-5.7.26\/data\n[root@node2 home]# mkdir -p \/home\/mysql-5.7.26\/log[root@node2 home]# mkdir -p \/home\/mysql-5.7.26\/run\n[root@node2 home]# mkdir -p \/home\/mysql-5.7.26\/tmp<\/pre>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
[root@node2 home]# chown -R mysql:mysql \/home\/mysql-5.7.26\/\n[root@node2 home]# ll\n\u603b\u7528\u91cf 0\ndrwxr-xr-x 6 mysql mysql 51 5\u6708   3 16:25 mysql-5.7.26\n[root@node2 home]# cd mysql-5.7.26\/\n[root@node2 mysql-5.7.26]# ll\n\u603b\u7528\u91cf 0\ndrwxr-xr-x 2 mysql mysql  6 5\u6708   3 16:24 data\ndrwxr-xr-x 4 mysql mysql 33 5\u6708   3 16:25 log\ndrwxr-xr-x 2 mysql mysql  6 5\u6708   3 16:25 run\n[root@node2 mysql-5.7.26]# chmod -R 755 \/home\/mysql-5.7.26\/\n[root@node2 mysql-5.7.26]# ll\n\u603b\u7528\u91cf 0\ndrwxr-xr-x 2 mysql mysql  6 5\u6708   3 16:24 data\ndrwxr-xr-x 4 mysql mysql 33 5\u6708   3 16:25 log\ndrwxr-xr-x 2 mysql mysql  6 5\u6708   3 16:25 run\n<\/pre>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
\u56db\u3001\u89e3\u538b\u6e90\u7801\u5305 <\/h3>\n\n\n\n
cd \/usr\/local\/src\/mysql-5.7.26-src\ntar -zxvf mysql-5.7.26.tar.gz <\/pre>\n\n\n\n
\u4e94\u3001\u5b89\u88c5\u76f8\u5173\u4f9d\u8d56\u5305<\/h3>\n\n\n\n
yum install cmake gcc gcc-c++ ncurses-devel bison zlib libxml openssl automake autoconf make libtool bison-devel libaio-devel openssl-devel<\/pre>\n\n\n\n
\u516d\u3001\u5b89\u88c5boost<\/h3>\n\n\n\n
cd \/usr\/local\nwget http:\/\/downloads.sourceforge.net\/project\/boost\/boost\/1.59.0\/boost_1_59_0.tar.gz\ntar -zxvf  boost_1_59_0.tar.gz<\/pre>\n\n\n\n
\u4e03\u3001\u7f16\u8bd1\u5b89\u88c5<\/h3>\n\n\n\n
cmake -DCMAKE_INSTALL_PREFIX=\/home\/mysql-5.7.31 -DINSTALL_DATADIR=\/home\/mysql-5.7.31\/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_SSL=yes -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=\/home\/mysql-5.7.31\/run\/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DSYSCONFDIR=\/etc -DWITH_READLINE=on -DWITH_BOOST=\/usr\/local\/boost_1_59_0<\/p>\n\n\n\n
cmake \\\n-DCMAKE_INSTALL_PREFIX=\/home\/mysql-5.7.26 \\    #\u5b89\u88c5\u76ee\u5f55<\/pre>\n\n\n\n
-DINSTALL_DATADIR=\/home\/mysql-5.7.26\/data \\  #\u6570\u636e\u76ee\u5f55<\/pre>\n\n\n\n
-DDEFAULT_CHARSET=utf8 \\   #\u9ed8\u8ba4\u7f16\u7801

-DDEFAULT_COLLATION=utf8_general_ci \\  #\u9ed8\u8ba4\u6821\u9a8c\u89c4\u5219

-DEXTRA_CHARSETS=all \\ 

-DWITH_SSL=yes \\ 

-DWITH_EMBEDDED_SERVER=1 \\ 

-DENABLED_LOCAL_INFILE=1 \\ 

-DWITH_MYISAM_STORAGE_ENGINE=1 \\    #\u6fc0\u6d3bmyisam

-DWITH_INNOBASE_STORAGE_ENGINE=1 \\  #\u6fc0\u6d3binnodb 

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \\    #

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \\ 

-DWITH_FEDERATED_STORAGE_ENGINE=1 \\ 

-DWITH_PARTITION_STORAGE_ENGINE=1 \\ 

-DMYSQL_UNIX_ADDR=\/home\/mysql-5.7.26\/run\/mysql.sock \\  #sock\u76ee\u5f55

-DMYSQL_TCP_PORT=3306 \\    #\u7aef\u53e3

-DENABLED_LOCAL_INFILE=1 \\  #\u5141\u8bb8\u5bfc\u5165\u6570\u636e

-DSYSCONFDIR=\/etc \\   

-DWITH_READLINE=on \\   #\u5feb\u6377\u952e\u529f\u80fd  

-DWITH_BOOST=\/usr\/local\/boost_1_59_0 \\  #\u589e\u5f3a\u63d2\u4ef6<\/pre>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
make<\/pre>\n\n\n\n
\u6700\u540e\u51fa\u73b0\uff1a<\/p>\n\n\n\n
[100%] Building CXX object mysql-test\/lib\/My\/SafeProcess\/CMakeFiles\/my_safe_process.dir\/safe_process.cc.o\nLinking CXX executable my_safe_process\n[100%] Built target my_safe_process<\/pre>\n\n\n\n
\u7f16\u8bd1\u6210\u529f\uff0c\u518d\u6267\u884c<\/p>\n\n\n\n
make install<\/pre>\n\n\n\n
\u6700\u540e\u51fa\u73b0\uff1a<\/p>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
-- Installing: \/home\/mysql-5.7.26\/.\/COPYING-test\n-- Installing: \/home\/mysql-5.7.26\/.\/README-test\n-- Up-to-date: \/home\/mysql-5.7.26\/mysql-test\/mtr\n-- Up-to-date: \/home\/mysql-5.7.26\/mysql-test\/mysql-test-run\n-- Installing: \/home\/mysql-5.7.26\/mysql-test\/lib\/My\/SafeProcess\/my_safe_process\n-- Up-to-date: \/home\/mysql-5.7.26\/mysql-test\/lib\/My\/SafeProcess\/my_safe_process\n-- Installing: \/home\/mysql-5.7.26\/mysql-test\/lib\/My\/SafeProcess\/Base.pm\n-- Installing: \/home\/mysql-5.7.26\/support-files\/mysqld_multi.server\n-- Installing: \/home\/mysql-5.7.26\/support-files\/mysql-log-rotate\n-- Installing: \/home\/mysql-5.7.26\/support-files\/magic\n-- Installing: \/home\/mysql-5.7.26\/share\/aclocal\/mysql.m4\n-- Installing: \/home\/mysql-5.7.26\/support-files\/mysql.server<\/pre>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
\u8fdb\u5165\/home\/mysql-5.7.26\/\u76ee\u5f55<\/p>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
[root@node2 mysql-5.7.26]# ll\n\u603b\u7528\u91cf 64\ndrwxr-xr-x  2 root  root   4096 5\u6708  15 09:08 bin\n-rw-r--r--  1 root  root  17987 4\u6708  13 21:32 COPYING\n-rw-r--r--  1 root  root  17987 4\u6708  13 21:32 COPYING-test\ndrwxr-xr-x  2 mysql mysql     6 5\u6708   3 16:24 data\ndrwxr-xr-x  2 root  root     55 5\u6708  15 09:08 docs\ndrwxr-xr-x  3 root  root   4096 5\u6708  15 09:08 include\ndrwxr-xr-x  4 root  root    192 5\u6708  15 09:08 lib\ndrwxr-xr-x  4 mysql mysql    33 5\u6708   3 16:25 log\ndrwxr-xr-x  4 root  root     30 5\u6708  15 09:08 man\ndrwxr-xr-x 10 root  root   4096 5\u6708  15 09:08 mysql-test\n-rw-r--r--  1 root  root   2478 4\u6708  13 21:32 README\n-rw-r--r--  1 root  root   2478 4\u6708  13 21:32 README-test\ndrwxr-xr-x  2 mysql mysql     6 5\u6708   3 16:25 run\ndrwxr-xr-x 28 root  root   4096 5\u6708  15 09:08 share\ndrwxr-xr-x  2 root  root     90 5\u6708  15 09:08 support-files\ndrwxr-xr-x  2 mysql mysql     6 5\u6708   3 16:25 tmp<\/pre>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
\u5b89\u88c5\u6210\u529f<\/p>\n\n\n\n
\u516b\u3001\u7f16\u5199\u914d\u7f6e\u6587\u4ef6my.cnf <\/h3>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
mkdir \/etc\/mysql\ncd \/etc\/mysql\nvim my.cnf\n<\/pre>\n\n\n
[mysqld]<\/p>\n\n\n\n
basedir=\/home\/mysql-5.7.26 datadir=\/home\/mysql-5.7.26\/data socket=\/home\/mysql-5.7.26\/mysql.sock user=mysql symbolic-links=0<\/p>\n\n\n
[mysqld_safe]<\/p>\n\n\n\n
log-error=\/home\/mysql-5.7.26\/log\/mysqld.log pid-file=\/home\/mysql-5.7.26\/run\/mysqld.pid<\/p>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
\u4e5d\u3001\u521d\u59cb\u5316\u7cfb\u7edf\u6570\u636e\u5e93<\/h3>\n\n\n\n
[root@node2 bin]# .\/mysqld \u2013defaults-file=\/etc\/mysql\/my.cnf --initialize --user=mysql --basedir=\/home\/mysql-5.7.26\/ --datadir=\/home\/mysql-5.7.26\/data\/ 

2019-05-15T06:29:58.880090Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-05-15T06:30:00.176430Z 0 [Warning] InnoDB: New log files created, LSN=45790 2019-05-15T06:30:00.525258Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2019-05-15T06:30:00.673537Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ddbee8c3-76da-11e9-9174-90b11c15be09. 2019-05-15T06:30:00.693221Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2019-05-15T06:30:01.209547Z 0 [Warning] CA certificate ca.pem is self signed. 2019-05-15T06:30:01.257442Z 1 [Note] A temporary password is generated for root@localhost: O3CaqsqoDy+V<\/pre>\n\n\n\n
\u8fd9\u91cc\u663e\u793a\u4e86\u7b2c\u4e00\u6b21\u767b\u9646\u65f6\u7684\u4e34\u65f6\u5bc6\u7801\uff0c\u9700\u8981\u8bb0\u4e0b\u6765<\/p>\n\n\n\n
\u5341\u3001\u542f\u52a8<\/h3>\n\n\n\n
[root@node2 bin]# touch \/home\/mysql-5.7.26\/log\/mysqld.log\n[root@node2 bin]# chown -R mysql:mysql \/home\/mysql-5.7.26\/log\/mysqld.log\n[root@node2 bin]# .\/mysqld_safe --defaults-file=\/etc\/mysql\/my.cnf --user=mysql\n2019-05-15T06:33:33.794898Z mysqld_safe Logging to '\/home\/mysql-5.7.26\/log\/mysqld.log'.\n2019-05-15T06:33:33.826283Z mysqld_safe Starting mysqld daemon with databases from \/home\/mysql-5.7.26\/data<\/pre>\n\n\n\n
 \u5341\u4e00\u3001\u6dfb\u52a0MySQL\u670d\u52a1 <\/h3>\n\n\n\n
cp \/home\/mysql-5.7.26\/support-files\/mysql.server \/etc\/init.d\/mysqld 

chmod 755 \/etc\/init.d\/mysqld<\/pre>\n\n\n\n
\u5341\u4e8c\u3001\u542f\u52a8\u670d\u52a1<\/h3>\n\n\n\n
[root@node2 bin]# service mysqld start\nStarting MySQL. SUCCESS! <\/pre>\n\n\n\n
\u5341\u4e09\u3001\u6dfb\u52a0mysql\u7684\u73af\u5883\u53d8\u91cf<\/h3>\n\n\n\n
vim \/etc\/profile\n\u6700\u540e\u4e00\u884c\u6dfb\u52a0\nexport PATH=\/home\/mysql-5.7.26\/bin:$PATH
source \/etc\/profile<\/pre>\n\n\n\n
\u5341\u56db\u3001\u8fde\u63a5mysql<\/h3>\n\n\n\n
 \u5148\u67e5\u770bmysqld.log\u65e5\u5fd7\uff0c\u67e5\u627e\u521d\u59cb\u5bc6\u7801\uff0c\u521d\u59cb\u5bc6\u7801\u662f\u5728\u7b2c\u4e00\u6b21\u8fd0\u884c\u521d\u59cb\u5316\u6570\u636e\u5e93\u65f6\u7531\u7cfb\u7edf\u751f\u6210\u7684<\/p>\n\n\n\n
[root@node2 data]# cat \/home\/mysql-5.7.26\/log\/mysqld.log |grep password\n2019-05-15T03:34:45.137254Z 1 [Note] A temporary password is generated for root@localhost: 1ws;,dEy?kM#<\/pre>\n\n\n\n
\u767b\u5f55<\/p>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
[root@node2 bin]# mysql -uroot -p\nEnter password: \nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 4\nServer version: 5.7.26\n\nCopyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql><\/pre>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
\u767b\u5f55\u6210\u529f\uff0c\u6b64\u65f6\u6267\u884c\u4efb\u4f55\u547d\u4ee4\uff0c\u63d0\u793a<\/p>\n\n\n\n
mysql> show databases;\nERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.<\/pre>\n\n\n\n
\u9700\u8981\u9996\u5148\u4fee\u6539\u5bc6\u7801<\/p>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
mysql> set PASSWORD=PASSWORD('xxxxxxxx');\nQuery OK, 0 rows affected, 1 warning (0.01 sec)\n\nmysql> alter user 'root'@'localhost' PASSWORD EXPIRE NEVER;\nQuery OK, 0 rows affected (0.00 sec)\n\nmysql> flush privileges;\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
\u9000\u51fa\uff0c\u91cd\u65b0\u767b\u5f55<\/p>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
[root@node2 log]# \/home\/mysql-5.7.26\/bin\/mysql -uroot -p\nEnter password: \nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 3\nServer version: 5.7.26 Source distribution\n\nCopyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql> show database;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| mysql              |\n| performance_schema |\n| sys                |\n+--------------------+\n4 rows in set (0.00 sec<\/pre>\n\n\n\n
\"\u590d\u5236\u4ee3\u7801\"\/<\/a><\/figure>\n\n\n\n
 \u53ef\u4ee5\u6267\u884c\u547d\u4ee4\u4e86<\/p>\n","protected":false},"excerpt":{"rendered":"
\u8f6c\u81ea https:\/\/www.cnblogs.co…<\/p>\n
Continue reading\u7f16\u8bd1\u5b89\u88c5mysql<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,2],"tags":[47],"_links":{"self":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts\/469"}],"collection":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=469"}],"version-history":[{"count":4,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts\/469\/revisions"}],"predecessor-version":[{"id":475,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts\/469\/revisions\/475"}],"wp:attachment":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}