<!DOCTYPE html>
MySQL安装
MySQL安装
Mysql安装方式有三种:
- rpm包安装
- 二进制安装
- mysql编译安装
环境说明
- 时间: 2017年8月6号
- 系统: CentOS-6.9-x86_64 最小化安装
- Mysql版本: 5.7.19
- 原创作品,允许转载,转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。
RPM安装
- 下载地址: https://dev.mysql.com/downloads/mysql/
- 下载方式
安装
- 上传至服务器任意位置
# ls -lhtotal 181M-rw-------. 1 root root 1.1K Jul 15 18:29 anaconda-ks.cfg-rw-r--r--. 1 root root 9.7K Jul 15 18:29 install.log-rw-r--r--. 1 root root 3.3K Jul 15 18:29 install.log.syslog-rw-r--r-- 1 root root 23M Aug 6 18:40 mysql-community-client-5.7.19-1.el6.x86_64.rpm-rw-r--r-- 1 root root 329K Aug 6 18:40 mysql-community-common-5.7.19-1.el6.x86_64.rpm-rw-r--r-- 1 root root 2.1M Aug 6 18:40 mysql-community-libs-5.7.19-1.el6.x86_64.rpm-rw-r--r-- 1 root root 1.7M Aug 6 18:40 mysql-community-libs-compat-5.7.19-1.el6.x86_64.rpm-rw-r--r-- 1 root root 153M Aug 6 18:40 mysql-community-server-5.7.19-1.el6.x86_64.rpm-rw-r--r-- 1 root root 2.1M Aug 6 18:40 postfix-2.6.6-8.el6.x86_64.rpm
yum 安装,会自动安装关联包
# yum -y install mysql-community-Loaded plugins: fastestmirrorSetting up Install ProcessExamining mysql-community-client-5.7.19-1.el6.x86_64.rpm: mysql-community-client-5.7.19-1.el6.x86_64Marking mysql-community-client-5.7.19-1.el6.x86_64.rpm to be installed.........Installed:mysql-community-client.x86_64 0:5.7.19-1.el6 mysql-community-common.x86_64 0:5.7.19-1.el6 mysql-community-libs.x86_64 0:5.7.19-1.el6mysql-community-libs-compat.x86_64 0:5.7.19-1.el6 mysql-community-server.x86_64 0:5.7.19-1.el6Dependency Installed:numactl.x86_64 0:2.0.9-2.el6Replaced:mysql-libs.x86_64 0:5.1.73-8.el6_8Complete!
配置
- 查看配置文件路径
# rpm -qc mysql-community-server-5.7.19/etc/logrotate.d/mysql/etc/my.cnf
- 启动mysql
# service mysqld startInitializing MySQL database:Starting mysqld:
- 根据配置文件找到mysql的错误日志路径
# grep "temporary password" /var/log/mysqld.log2017-08-06T10:50:48.543649Z 1 for root@localhost: 5U2tMJBw8d-m A temporary password is generated
使用密码连接
# mysql -uroot -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 7Server version: 5.7.19Copyright 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
- rpm安装完毕
二进制安装
- 下载地址: https://dev.mysql.com/downloads/mysql/
- 下载方式
安装
- 上传包至服务器任意路径
# ls -lhtotal 611M-rw-------. 1 root root 1.1K Jul 15 18:29 anaconda-ks.cfg-rw-r--r--. 1 root root 9.7K Jul 15 18:29 install.log-rw-r--r--. 1 root root 3.3K Jul 15 18:29 install.log.syslog-rw-r--r-- 1 root root 611M Aug 6 19:36 mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
安装
1. 解压到指定/opt目录,软连接# tar xf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz -C /opt/# cd /opt/# ls -lhtotal 4.0Kdrwxr-xr-x 9 root root 4.0K Aug 6 19:38 mysql-5.7.19-linux-glibc2.12-x86_64# ln -sv mysql-5.7.19-linux-glibc2.12-x86_64 mysql</span></span><span>mysql</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ->
mysql-5.7.19-linux-glibc2.12-x86_64'# cd mysql2. 新建mysql用户,并对/opt/mysql目录赋权[root@mysql mysql]# useradd -s /sbin/nologin -M -u 3306 mysql[root@mysql mysql]# id mysqluid=3306(mysql) gid=3306(mysql) groups=3306(mysql)[root@mysql mysql]# chown mysql.mysql -R /opt/mysql3.编辑配置文件,这个版本并没有提供默认的配置文件[root@mysql mysql]# vim my.cnf[mysqld]datadir = /opt/mysql/dataport = 3306socket = /opt/mysql/mysqld.sockskip_name_resolve4. 启动脚本[root@mysql mysql]# cp -av support-files/mysql.server /etc/init.d/mysqld</span></span></span><span>support-files/mysql.server</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ->
/etc/init.d/mysqld'# vim /etc/init.d/mysqldbasedir=/opt/mysqldatadir=\({</span></span><span>basedir</span><span class="syntax--punctuation syntax--definition syntax--variable syntax--shell"><span>}</span></span></span><span>/data</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span> </span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>5. 初始化MySQL数据库</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>root@mysql mysql</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span class="syntax--comment syntax--line syntax--number-sign syntax--shell"><span class="syntax--punctuation syntax--definition syntax--comment syntax--shell"><span>#</span></span><span> /opt/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>/opt/mysql/bin/mysqld: error </span><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span class="syntax--keyword syntax--control syntax--shell"><span>while</span></span><span> loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>root@mysql mysql</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span class="syntax--comment syntax--line syntax--number-sign syntax--shell"><span class="syntax--punctuation syntax--definition syntax--comment syntax--shell"><span>#</span></span><span> yum provides libnuma.so.1 # 搜索该库是由哪个包提供</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Loaded plugins: fastestmirror</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Determining fastest mirrors</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span class="syntax--keyword syntax--operator syntax--glob syntax--shell"><span>*</span></span><span> base: mirrors.aliyun.com</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span class="syntax--keyword syntax--operator syntax--glob syntax--shell"><span>*</span></span><span> extras: mirrors.aliyun.com</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span class="syntax--keyword syntax--operator syntax--glob syntax--shell"><span>*</span></span><span> updates: mirrors.aliyun.com</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>base </span><span class="syntax--keyword syntax--operator syntax--pipe syntax--shell"><span>|</span></span><span> 3.7 kB 00:00 </span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>extras </span><span class="syntax--keyword syntax--operator syntax--pipe syntax--shell"><span>|</span></span><span> 3.4 kB 00:00 </span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>updates </span><span class="syntax--keyword syntax--operator syntax--pipe syntax--shell"><span>|</span></span><span> 3.4 kB 00:00 </span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>updates/primary_db </span><span class="syntax--keyword syntax--operator syntax--pipe syntax--shell"><span>|</span></span><span> 2.5 MB 00:02 </span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>numactl-2.0.9-2.el6.i686 </span><span class="syntax--support syntax--function syntax--builtin syntax--shell"><span>:</span></span><span> Library </span><span class="syntax--keyword syntax--control syntax--shell"><span>for</span></span><span> tuning </span><span class="syntax--keyword syntax--control syntax--shell"><span>for</span></span><span> Non Uniform Memory Access machines</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Repo </span><span class="syntax--support syntax--function syntax--builtin syntax--shell"><span>:</span></span><span> base</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Matched from:</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Other </span><span class="syntax--support syntax--function syntax--builtin syntax--shell"><span>:</span></span><span> libnuma.so.1</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>root@mysql mysql</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span class="syntax--comment syntax--line syntax--number-sign syntax--shell"><span class="syntax--punctuation syntax--definition syntax--comment syntax--shell"><span>#</span></span><span> yum -y install numactl</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Loaded plugins: fastestmirror</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Setting up Install Process</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Loading mirror speeds from cached hostfile</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>...</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>...</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>...</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Installed:</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>numactl.x86_64 0:2.0.9-2.el6 </span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span> </span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>Complete</span><span class="syntax--keyword syntax--operator syntax--pipe syntax--shell"><span>!</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span> </span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>root@mysql mysql</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span class="syntax--comment syntax--line syntax--number-sign syntax--shell"><span class="syntax--punctuation syntax--definition syntax--comment syntax--shell"><span>#</span></span><span> /opt/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>2017-08-06T12:45:23.699674Z 0 </span><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>Warning</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span> TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option </span><span class="syntax--meta syntax--scope syntax--subshell syntax--shell"><span class="syntax--punctuation syntax--definition syntax--subshell syntax--shell"><span>(</span></span><span>see documentation </span><span class="syntax--keyword syntax--control syntax--shell"><span>for</span></span><span> more details</span><span class="syntax--punctuation syntax--definition syntax--subshell syntax--shell"><span>)</span></span></span><span>.</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>2017-08-06T12:45:25.059615Z 0 </span><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>Warning</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span> InnoDB: New log files created, LSN=45790</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>2017-08-06T12:45:25.446617Z 0 </span><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>Warning</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span> InnoDB: Creating foreign key constraint system tables.</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>2017-08-06T12:45:25.511614Z 0 </span><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>Warning</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span> No existing UUID has been found, so we assume that this is the first </span><span class="syntax--keyword syntax--other syntax--shell"><span>time</span></span><span> that this server has been started. Generating a new UUID: 1e543114-7aa5-11e7-9a69-000c29d408d3.</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>2017-08-06T12:45:25.515037Z 0 </span><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>Warning</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span> Gtid table is not ready to be used. Table </span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span>mysql.gtid_executed</span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span> cannot be opened.</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>2017-08-06T12:45:25.516517Z 1 </span><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>Warning</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span> root@localhost is created with an empty password </span><span class="syntax--keyword syntax--operator syntax--pipe syntax--shell"><span>!</span></span><span> Please consider switching off the --initialize-insecure option.</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span> </span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>6. 添加环境变量及MAN配置文件</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>root@mysql mysql</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span class="syntax--comment syntax--line syntax--number-sign syntax--shell"><span class="syntax--punctuation syntax--definition syntax--comment syntax--shell"><span>#</span></span><span> mysql</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span>-bash: mysql: </span><span class="syntax--support syntax--function syntax--builtin syntax--shell"><span>command</span></span><span> not found</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--while-loop syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>root@mysql mysql</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span class="syntax--comment syntax--line syntax--number-sign syntax--shell"><span class="syntax--punctuation syntax--definition syntax--comment syntax--shell"><span>#</span></span><span> echo 'export PATH=/opt/mysql/bin:\)PATH' > /etc/profile.d/mysqld.sh && . /etc/profile.d/mysqld.sh
- 二进制安装完毕
编译安装
- 下载地址: https://dev.mysql.com/downloads/mysql/
- 下载方式
安装(
CPU越多越好,1核无法编译成功
)
准备依赖环境
# yum -y install cmake ncurses-devel gcc-c++Loaded plugins: fastestmirrorSetting up Install ProcessDetermining fastest mirrorsbase: mirrors.zju.edu.cnextras: mirrors.btte.netupdates: mirrors.aliyun.combase | 3.7 kB 00:00extras | 3.4 kB 00:00updates | 3.4 kB 00:00updates/primary_db | 2.5 MB 00:02Resolving Dependencies--> Running transaction check---> Package cmake.x86_64 0:2.8.12.2-4.el6 will be installed--> Processing Dependency:.........Installed:cmake.x86_64 0:2.8.12.2-4.el6 gcc-c++.x86_64 0:4.4.7-18.el6 ncurses-devel.x86_64 0:5.7-4.20090207.el6Dependency Installed:cloog-ppl.x86_64 0:0.15.7-1.2.el6 cpp.x86_64 0:4.4.7-18.el6 gcc.x86_64 0:4.4.7-18.el6 glibc-devel.x86_64 0:2.12-1.209.el6_9.2 glibc-headers.x86_64 0:2.12-1.209.el6_9.2kernel-headers.x86_64 0:2.6.32-696.6.3.el6 libarchive.x86_64 0:2.8.3-7.el6_8 libgomp.x86_64 0:4.4.7-18.el6 libstdc++-devel.x86_64 0:4.4.7-18.el6 mpfr.x86_64 0:2.4.1-6.el6ppl.x86_64 0:0.10.2-11.el6Dependency Updated:glibc.x86_64 0:2.12-1.209.el6_9.2 glibc-common.x86_64 0:2.12-1.209.el6_9.2Complete!- 上传源码包至linux随意路径
# tar xf mysql-boost-5.7.19.tar.gz# cd mysql-5.7.19/
开始编译
# cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql </span>> -DMYSQL_DATADIR=/opt/mysql/data </span>> -DSYSCONFDIR=/opt/mysql/ </span>> -DWITH_BOOST=boost </span>> -DWITH_MYISAM_STORAGE_ENGINE=1 </span>> -DWITH_INNOBASE_STORAGE_ENGINE=1 </span>> -DWITH_MEMORY_STORAGE_ENGINE=1 </span>> -DWITH_READLINE=1 </span>> -DMYSQL_UNIX_ADDR=/opt/mysql/mysqld.sock </span>> -DMYSQL_TCP_PORT=3306 </span>> -DENABLED_LOCAL_INFILE=1 </span>> -DWITH_PARTITION_STORAGE_ENGINE=1 </span>> -DENABLE_DOWNLOADS=1 </span>> -DEXTRA_CHARSETS=all </span>> -DDEFAULT_CHARSET=utf8 </span>> -DDEFAULT_COLLATION=utf8_general_ci-- Running cmake version 2.8.12.2-- Could NOT find Git-- Configuring with MAX_INDEXES = 64U-- The C compiler identification is GNU 4.4.7-- The CXX compiler identification is GNU 4.4.7-- Check for working C compiler: /usr/bin/cc.........-- CMAKE_CXX_FLAGS_RELWITHDEBINFO: -O3 -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF-- Configuring done-- Generating doneCMake Warning:Manually-specified variables were not used by the project:WITH_MEMORY_STORAGE_ENGINEWITH_READLINE-- Build files have been written to: /root/mysql-5.7.19# echo \(? # 输出状态码可以判断上述命令是否执行成功,为0就成功,其他状态码都是失败</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>0</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>root@1 mysql-5.7.19</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span class="syntax--comment syntax--line syntax--number-sign syntax--shell"><span class="syntax--punctuation syntax--definition syntax--comment syntax--shell"><span>#</span></span><span> make -j 2 && make install # -j 2 指定用2核CPU编译</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>Scanning dependencies of target INFO_BIN</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>Scanning dependencies of target INFO_SRC</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span> 0%</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span> Built target INFO_SRC</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span> 0%</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span> Built target INFO_BIN</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>Scanning dependencies of target abi_check</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>Scanning dependencies of target zlib</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span> 0%</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span> Building C object zlib/CMakeFiles/zlib.dir/adl</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>...</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>等待编译</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>...</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Installing: /opt/mysql/mysql-test/./mysql-test-run</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Up-to-date: /opt/mysql/mysql-test/mtr</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Up-to-date: /opt/mysql/mysql-test/mysql-test-run</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Installing: /opt/mysql/mysql-test/lib/My/SafeProcess/my_safe_process</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Up-to-date: /opt/mysql/mysql-test/lib/My/SafeProcess/my_safe_process</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Installing: /opt/mysql/mysql-test/lib/My/SafeProcess/Base.pm</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Installing: /opt/mysql/support-files/mysqld_multi.server</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Installing: /opt/mysql/support-files/mysql-log-rotate</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Installing: /opt/mysql/support-files/magic</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Installing: /opt/mysql/share/aclocal/mysql.m4</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>-- Installing: /opt/mysql/support-files/mysql.server</span></span></div></pre> </li> <li><p>安装后的后续操作</p> <pre class="editor-colors lang-shell"><div class="line"><span class="syntax--source syntax--shell"><span>1. 添加mysql用户及将修改相应文件夹属主属组</span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>root@1 support-files</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span class="syntax--comment syntax--line syntax--number-sign syntax--shell"><span class="syntax--punctuation syntax--definition syntax--comment syntax--shell"><span>#</span></span><span> useradd -u 3306 -M -s /sbin/nologin mysql</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--meta syntax--scope syntax--logical-expression syntax--shell"><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>[</span></span><span>root@1 support-files</span><span class="syntax--punctuation syntax--definition syntax--logical-expression syntax--shell"><span>]</span></span></span><span class="syntax--comment syntax--line syntax--number-sign syntax--shell"><span class="syntax--punctuation syntax--definition syntax--comment syntax--shell"><span>#</span></span><span> mkdir -pv /opt/mysql/data && chown mysql.mysql -R /opt/mysql</span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span>mkdir: created directory </span><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>`</span></span><span>/opt/mysql/data</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span> </span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2. 准备my.cnf配置文件及mysql启动脚本,由于5.7.19并没有提供默认的配置文件,只能自己写了</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>vim /opt/mysql/my.cnf</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>[mysqld]</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>datadir = /opt/mysql/data</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>port = 3306</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>socket = /opt/mysql/mysqld.sock</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>skip_name_resolve</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>[root@1 support-files]# cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld && chmod +x /etc/init.d/mysqld</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span> </span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>3. 执行初始化命令, 5.7集成在mysql命令中</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>[root@1 support-files]# cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld && chmod +x /etc/init.d/mysqld</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>[root@1 support-files]# /opt/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:01.666326Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:03.364801Z 0 [Warning] InnoDB: New log files created, LSN=45790</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:03.525083Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:03.697839Z 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: f85cf1a8-7ac8-11e7-8e48-000c29d408d3.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:03.701251Z 0 [Warning] Gtid table is not ready to be used. Table </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>mysql.gtid_executed</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> cannot be opened.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:03.713104Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:05.479148Z 1 [Warning] </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>user</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> entry </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>root@localhost</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ignored in --skip-name-resolve mode.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:05.479171Z 1 [Warning] </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>user</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> entry </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>mysql.session@localhost</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ignored in --skip-name-resolve mode.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:05.479178Z 1 [Warning] </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>user</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> entry </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>mysql.sys@localhost</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ignored in --skip-name-resolve mode.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:05.479188Z 1 [Warning] </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>db</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> entry </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>performance_schema mysql.session@localhost</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ignored in --skip-name-resolve mode.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:05.479192Z 1 [Warning] </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>db</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> entry </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>sys mysql.sys@localhost</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ignored in --skip-name-resolve mode.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:05.479198Z 1 [Warning] </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>proxies_priv</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> entry </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>@ root@localhost</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ignored in --skip-name-resolve mode.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:05.479219Z 1 [Warning] </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>tables_priv</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> entry </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>user mysql.session@localhost</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ignored in --skip-name-resolve mode.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>2017-08-06T17:02:05.479226Z 1 [Warning] </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>tables_priv</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> entry </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>sys_config mysql.sys@localhost</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> ignored in --skip-name-resolve mode.</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span> </span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>4. 添加man手册及添加环境变量</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>[root@1 support-files]# sed -i </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>43a </span><span class="syntax--constant syntax--character syntax--escape syntax--shell"><span>\M</span></span><span>ANPATH /opt/mysql/man</span><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span class="syntax--punctuation syntax--definition syntax--string syntax--begin syntax--shell"><span>'</span></span><span> /etc/man.config</span></span></span></span></div><div class="line"><span class="syntax--source syntax--shell"><span class="syntax--string syntax--interpolated syntax--backtick syntax--shell"><span class="syntax--string syntax--quoted syntax--single syntax--shell"><span>[root@1 support-files]# echo </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span>export PATH=/opt/mysql/bin:</span><span class="syntax--variable syntax--other syntax--normal syntax--shell"><span class="syntax--punctuation syntax--definition syntax--variable syntax--shell"><span>\)PATH ' > /etc/profile.d/mysqld.sh && . /etc/profile.d/mysqld.sh5. 添加至开机启动项[root@1 support-files]# chkconfig mysqld on6. 输出mysql的头文件至系统头文件路径/usr/include[root@1 support-files]# ln -sv /opt/mysql/include /usr/include/mysql/usr/include/mysql</span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>'</span></span></span><span> -</span><span class="syntax--keyword syntax--operator syntax--redirect syntax--shell"><span>></span></span><span> </span><span class="syntax--punctuation syntax--definition syntax--string syntax--end syntax--shell"><span>
/opt/mysql/include'7. 输出mysql的库文件给系统查找路径[root@1 support-files]# echo '/opt/mysql/lib' >> /etc/ld.so.conf.d/mysql-x86_64.conf[root@1 support-files]# ldconfig8. 启动并连接mysql[root@1 support-files]# service mysqld startStarting MySQL. SUCCESS![root@1 support-files]# mysqlWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.7.19 Source distributionCopyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>9. mysql5.7密码表select Host,User,authentication_string from mysql.user;