Mysql安装

缺乏、安全感 2021-09-19 05:00 337阅读 0赞

**Mysql安装（源码安装）：系统环境: RHEL 6.5x86-64**

所需软件：

cmake-2.8.12.2-4.el6.x86\_64.rpm

mysql-boost-5.7.17.tar.gz

yum install -y gcc gcc-c++ ncurses-devel  openssl-devel

cmake-DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql \\   \#安装目录

\-DMYSQL\_DATADIR=/usr/local/mysql/data\\    \#数据库存放目录

\-DMYSQL\_UNIX\_ADDR=/usr/local/mysql/data/mysql.sock\\  \#Unix socket 文件路径

\-DWITH\_MYISAM\_STORAGE\_ENGINE=1\\   \#安装 myisam 存储引擎

\-DWITH\_INNOBASE\_STORAGE\_ENGINE=1\\   \#安装 innodb 存储引擎

\-DWITH\_ARCHIVE\_STORAGE\_ENGINE=1\\   \#安装 archive 存储引擎

\-DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1\\  \#安装blackhole 存储引擎

\-DWITH\_PARTITION\_STORAGE\_ENGINE=1\\   \#安装数据库分区

\-DENABLED\_LOCAL\_INFILE=1\\   \#允许从本地导入数据

\-DWITH\_READLINE=1\\   \#快捷键功能

\-DWITH\_SSL=yes \\  \#支持 SSL

\-DDEFAULT\_CHARSET=utf8\\   \#使用 utf8 字符

\-DDEFAULT\_COLLATION=utf8\_general\_ci\\   \#校验字符

\-DEXTRA\_CHARSETS=all\\    \#安装所有扩展字符集

\-DMYSQL\_TCP\_PORT=3306\\   \#MySQL 监听端口

操作步骤：

（1）安装软件

141 tar zxf mysql-boost-5.7.17.tar.gz

145  cd mysql-5.7.17/

150  yum install -y cmake-2.8.12.2-4.el6.x86\_64.rpm

151  yuminstall -y gcc gcc-c++ ncurses-devel  openssl-devel

\#\#\#\# 解决依赖性软件

152  ls

162  rm-fr CMakeCache.txt

163 cmake -DCMAKE\_INSTALL\_PREFIX=/usr/local/lnmp/mysq -DMYSQL\_DATADIR=/usr/local/lnmp/mysql/data -DMYSQL\_UNIX\_ADDR=/usr/local/lnmp/mysql/data/mysql.sock -DWITH\_MYISAM\_STORAGE\_ENGINE=1-DWITH\_INNOBASE\_STORAGE\_ENGINE=1 -DDEFAULT\_CHARSET=utf8-DDEFAULT\_COLLATION=utf8\_general\_ci -DEXTRA\_CHARSETS=all-DWITH\_BOOST=boost/boost\_1\_59\_0/   \#\#\#根据上面的cmake查看意思。     看到最后一行显示\-- Build files have been written to:/root/mysql-5.7.17 ，即位加载成功

164  make && make install 编译和安装

截图：

[![wKioL1l8bv3xV9drAAD-0WHEa9U128.png-wh\_50][wKioL1l8bv3xV9drAAD-0WHEa9U128.png-wh_50]][wKioL1l8bv3xV9drAAD-0WHEa9U128.png-wh_50]

\#\#\#\#加载过程中的问题及解决的方法截图：

[![wKioL1l8bwCACJvaAAKtkLcT8Vw983.png-wh\_50][wKioL1l8bwCACJvaAAKtkLcT8Vw983.png-wh_50]][wKioL1l8bwCACJvaAAKtkLcT8Vw983.png-wh_50]

[![wKiom1l8bwPim4PvAALIY60a\_sI271.png-wh\_50][wKiom1l8bwPim4PvAALIY60a_sI271.png-wh_50]][wKiom1l8bwPim4PvAALIY60a_sI271.png-wh_50]

[![wKiom1l8bwXSDv0qAAJaIhCe2UI890.png-wh\_50][wKiom1l8bwXSDv0qAAJaIhCe2UI890.png-wh_50]][wKiom1l8bwXSDv0qAAJaIhCe2UI890.png-wh_50]

(2)添加用户及用户组

[![wKioL1l8bwbTGozLAADR1wj6i10286.png-wh\_50][wKioL1l8bwbTGozLAADR1wj6i10286.png-wh_50]][wKioL1l8bwbTGozLAADR1wj6i10286.png-wh_50]

[![wKiom1l8cCviSuz7AADjK\_pr3Io718.png-wh\_50][wKiom1l8cCviSuz7AADjK_pr3Io718.png-wh_50]][wKiom1l8cCviSuz7AADjK_pr3Io718.png-wh_50]

166  df-h （只有used在9G以上才可以执行下列操作）

167  id mysql   \#\#\#查看用户

169 groupadd -g 27 mysql   建立用户组

170 useradd -u 27 -g 27 -s /sbin/nologin -M -d  /usr/local/lnmp/mysql mysql

171  idmysql

172 vim /etc/passwd

将数据库的路径改成如图;

[![wKioL1l8cCHQpGN2AAECXekcn1Q230.png-wh\_50][wKioL1l8cCHQpGN2AAECXekcn1Q230.png-wh_50]][wKioL1l8cCHQpGN2AAECXekcn1Q230.png-wh_50]

173  pwd

178  cd/usr/local/lnmp/mysql/

179  ls

180  cd bin/

181  ls

182 pwd

183 vim ~/.bash\_profile  \#\#\#修改环境变量

如图：

[![wKiom1l8cCKSvI5UAACGSpOBf3I095.png-wh\_50][wKiom1l8cCKSvI5UAACGSpOBf3I095.png-wh_50]][wKiom1l8cCKSvI5UAACGSpOBf3I095.png-wh_50]

184 source ~/.bash\_profile

185 which mysql

[![wKioL1l8cCOgd134AAJEbwaB76o760.png-wh\_50][wKioL1l8cCOgd134AAJEbwaB76o760.png-wh_50]][wKioL1l8cCOgd134AAJEbwaB76o760.png-wh_50]

186  cd..

187  ls

188  cd/etc

189  ls

190  cpmy.cnf  my.cnf.bak   \#\#备份文件/etc/my.cnf

191  cd /usr/local/lnmp/mysql/

192  ls

193  cdsupport-files/

194  ls

195 vim my-default.cnf

196  cpmy-default.cnf  /etc/my.cnf  \#\#\#将my-default.cnf文件复制到/etc/my.cnf

197 vim mysql-log-rotate

198  cpmysql.server  /etc/init.d/mysqld  \#\#\#\#\#将mysql.server文件复制到 /etc/init.d/mysqld

199 rpm -qa|grep  mysql

[![wKiom1l8cCbgZzDYAANr3pELy80005.png-wh\_50][wKiom1l8cCbgZzDYAANr3pELy80005.png-wh_50]][wKiom1l8cCbgZzDYAANr3pELy80005.png-wh_50]

200  cd..

202 chown root.root . -R

204 chown mysql.mysql . -R  \#\#\#\# 修改/usr/local/lnmp/mysql的权限

205 mysqld --initialize   --user=mysql    \#\#\#获取动态密码

206  ls

207  cd data

208  ls

209  cd

210  cd  mysql-5.7.17/

211  ls

212  cd support-files/

213  ls

214  cd

215 /etc/init.d/mysqld start  \#\#\#开启数据库

219 mysql -p

220 mysql\_secure\_installation  \#\#\#数据库密码重设

[![wKioL1l8cCqgEFTjAAKbvk4DMok645.png-wh\_50][wKioL1l8cCqgEFTjAAKbvk4DMok645.png-wh_50]][wKioL1l8cCqgEFTjAAKbvk4DMok645.png-wh_50]

221 mysql -p

能进入数据库，且能进行操作。

本文转自 如何何如  51CTO博客，原文链接：http://blog.51cto.com/12778805/1951994，如需转载请自行联系原作者

[wKioL1l8bv3xV9drAAD-0WHEa9U128.png-wh_50]: /images/20210726/280bbf1067b0496f93453dec63f9ad16.png
[wKioL1l8bwCACJvaAAKtkLcT8Vw983.png-wh_50]: /images/20210726/de25041e78854786a361f8fe8731adce.png
[wKiom1l8bwPim4PvAALIY60a_sI271.png-wh_50]: /images/20210726/7f37a0d4970f483db29799d0f379ab45.png
[wKiom1l8bwXSDv0qAAJaIhCe2UI890.png-wh_50]: /images/20210726/a37dd7d29f0c46a6bc14657c79030100.png
[wKioL1l8bwbTGozLAADR1wj6i10286.png-wh_50]: /images/20210726/af015114465340ff93aa2b07dbbac2ee.png
[wKiom1l8cCviSuz7AADjK_pr3Io718.png-wh_50]: /images/20210726/d4f1d4d49992417b907f2e10fb87e3a6.png
[wKioL1l8cCHQpGN2AAECXekcn1Q230.png-wh_50]: /images/20210726/9453f187a15e49d4bfaf100185bd33c5.png
[wKiom1l8cCKSvI5UAACGSpOBf3I095.png-wh_50]: /images/20210726/3743342857a84596992de014fb5aa6f9.png
[wKioL1l8cCOgd134AAJEbwaB76o760.png-wh_50]: /images/20210726/ef8a6364b81843dab62122b08b0e635f.png
[wKiom1l8cCbgZzDYAANr3pELy80005.png-wh_50]: https://s1.51cto.com/wyfs02/M01/9D/40/wKiom1l8cCbgZzDYAANr3pELy80005.png-wh_500x0-wm_3-wmp_4-s_287785813.png
[wKioL1l8cCqgEFTjAAKbvk4DMok645.png-wh_50]: /images/20210726/709b49a97a96462999fc85ef08d63169.png