源码编译安装MySQL服务

喜欢ヅ旅行 2024-04-08 11:56 15阅读 0赞

**目录**

一、安装依赖环境（在安装了Nginx的基础上）

二、创建运行用户

三、 编译安装

四、调整配置文件

五、数据库操作

--------------------

准备工作，把mysql-boost-5.7.20.tar.gz放到/opt下

## 一、安装依赖环境（在安装了Nginx的基础上） ##

yum -y install gcc gcc-c++ pcre-devel zlib-devel make

yum -y install \\

ncurses \\

ncurses-devel \\

bison \\

cmake

## 二、创建运行用户 ##

useradd -s /sbin/nologin mysql

![bf0c9f1180a549ee92efccddf2dd0d4c.png][]

## 三、 编译安装 ##

1、cd /opt 到/opt 目录下

tar xzvf mysql-boost-5.7.20.tar.gz 解压

![5381a6133d66446687032168c3c068ad.png][]

2、进入目录内

![c1c76c2cd288483592fea9f4a0af1a42.png][]

3、编译

cmake \\ -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql \\

\-DMYSQL\_UNIX\_ADDR=/usr/local/mysql/mysql.sock \\ -DSYSCONFDIR=/etc \\

\-DSYSTEMD\_PID\_DIR=/usr/local/mysql \\ -DDEFAULT\_CHARSET=utf8 \\

\-DDEFAULT\_COLLATION=utf8\_general\_ci \\ -DWITH\_INNOBASE\_STORAGE\_ENGINE=1 \\

\-DWITH\_ARCHIVE\_STORAGE\_ENGINE=1 \\ -DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 \\

\-DWITH\_PERFSCHEMA\_STORAGE\_ENGINE=1 \\ -DMYSQL\_DATADIR=/usr/local/mysql/data \\

\-DWITH\_BOOST=boost \\ -DWITH\_SYSTEMD=1

\[root@zwb mysql-5.7.20\]\# make -j3 && make install \#\#\#\#\#\#\#\# -j3加快编译的速度

如果在CMAKE 这出现了报错。操作如下：

3.1、删除CMakeCache.txt文件2

![20243113e803417ba862558447170d49.png][]3.2、 到 [http://ftp.gnu.org/pub/gnu/ncurses/ncurses-5.6.tar.gz][http_ftp.gnu.org_pub_gnu_ncurses_ncurses-5.6.tar.gz]

进行下载放到opt下。

3.3、cd /opt

tar zxvf ncurses-5.6.tar.gz

cd ncurses-5.6 在该目录下完成一下操作

①./configure -prefix=/usr/local -with-shared-without-debug

②make

③make installs

chown -R mysql:mysql /usr/local/mysql/

4、数据库目录进行权限调整

![d44d99f81c504ac9a7438c6f4a732011.png][]

## 四、调整配置文件 ##

1、vim /etc/my.cnf \#\#\#\#\#\#\#\#\#清空原文件内容

添加内容：

\[client\]  
port = 3306  
default-character-set=utf8  
socket = /usr/local/mysql/mysql.sock

\[mysql\]  
port = 3306  
default-character-set=utf8  
socket = /usr/local/mysql/mysql.sock

\[mysqld\]  
user = mysql  
basedir = /usr/local/mysql  
datadir = /usr/local/mysql/data  
port = 3306  
character\_set\_server=utf8  
pid-file = /usr/local/mysql/mysqld.pid  
socket = /usr/local/mysql/mysql.sock  
server-id = 1

sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES,NO\_AUTO\_CREATE\_USER,NO\_AUTO\_VALUE\_ON\_ZERO,NO\_ZERO\_IN\_DATE,NO\_ZERO\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,PIPES\_AS\_CONCAT,ANSI\_QUOTES

![55624c03a7124d04b04600962b882583.png][]

2、给与my.cnf权限

![425b211e054146718eb79d26600f9040.png][]

3、 设置环境变量

![9bb02483bed849eb8937142646d57707.png][]

4、 初始化数据库

![5f7011267fbc4c919ea1fafce8a7486a.png][]

5、 把mysqld.service复制到/usr/lib/systemd/system/下

cp usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/

![62095317ea9c40a3a8aa8f41a4ae8730.png][]

6、开启数据库并设置为开机自启动

\[root@zwb mysql\]\# systemctl enable mysqld.service --now

![12166e6fb5fe40a6be407567883b6f86.png][]

7、查看mysql端口

![2bd94030b0254bc188f6546a6ca7858e.png][]

## 五、数据库操作 ##

1、修改数据库密码。默认为空

mysqladmin -u root -p password

![a5d51d67b3dd461e8881fe31ab3ef65b.png][]

2、登录数据库方法

①mysql -u root -p![0c2b23cb32b24a8ba3852626da4aacf5.png][]

②mysql -uroot -pabc123

![ad0bd452c2a24c368cbec35589ec29f1.png][]

[bf0c9f1180a549ee92efccddf2dd0d4c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/fad748573a514abc91eb5ba37efade77.png
[5381a6133d66446687032168c3c068ad.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/841149b29c2e4699bc946e06e2a8616a.png
[c1c76c2cd288483592fea9f4a0af1a42.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/6c906e5a88f34dd9bcc78c92e2d70307.png
[20243113e803417ba862558447170d49.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/ba35cd6944a24701931b48c8e6a87d89.png
[http_ftp.gnu.org_pub_gnu_ncurses_ncurses-5.6.tar.gz]: http://ftp.gnu.org/pub/gnu/ncurses/ncurses-5.6.tar.gz
[d44d99f81c504ac9a7438c6f4a732011.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/e1e1bfe3d59c4a99a2cdea9c1bca22c9.png
[55624c03a7124d04b04600962b882583.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/bb5e0459db5049efbe299e6679f7ce39.png
[425b211e054146718eb79d26600f9040.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/b6c51151b1534474b918a96755732aeb.png
[9bb02483bed849eb8937142646d57707.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/03cc92cef08743a5a00495af061ab2a8.png
[5f7011267fbc4c919ea1fafce8a7486a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/f0be3e0010cc4094a255cb7a0bad16b5.png
[62095317ea9c40a3a8aa8f41a4ae8730.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/ee0f51d5886e4ea39be9c02df8b361b2.png
[12166e6fb5fe40a6be407567883b6f86.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/8ce8d92138f643598242446c275c3dd6.png
[2bd94030b0254bc188f6546a6ca7858e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/22e8bcc1502a410a9d797e338c203d71.png
[a5d51d67b3dd461e8881fe31ab3ef65b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/abea32d9163d4076aecc008725c2ad66.png
[0c2b23cb32b24a8ba3852626da4aacf5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/4ae049cd3a214b2081b7b2c84f43996e.png
[ad0bd452c2a24c368cbec35589ec29f1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/b92528ba4bad4601abe6396ae3dd55ac.png