mysql 编译源码_MySQL源码编译与初始化

旧城等待， 2023-01-11 03:37 139阅读 0赞

MySQL源码编译与初始化

1.MySQL简介

1.1数据库有很多种类：

关系型数据库--->MySQL Oracle

非关系型数据库-->memcached redis

图形化数据库---->mongodb

阵列型(线形)数据库--->Hbase

时间序列数据库---->influxDB

1.2什么叫关系型数据库？？？

SQL数据库数据与数据之间是有关系的，通过关系能够将一系列数据都提取出来。

![1aa8d3d2e556ea507f1288b33fc6802a.png][]

1.3什么叫非关系型数据库？？？

NOSQL(Not only SQL)数据库

2.安装源码编译必备的几个软件包

\[root@yangwenbo yang\]\# yum -y install make gcc gcc-c++ ncurses-devel cmake

\[root@yangwenbo yang\]\# rpm -qa make gcc gcc-c++ ncurses-devel cmake

gcc-4.4.7-4.el6.x86\_64

cmake-2.6.4-5.el6.x86\_64

gcc-c++-4.4.7-4.el6.x86\_64

ncurses-devel-5.7-3.20090208.el6.x86\_64

make-3.81-20.el6.x86\_64

3.源码编译与安装

3.1源码编译cmake-2.8.6.tar.gz

\[root@yangwenbo yang\]\# ls

cmake-2.8.6.tar.gz mysql-5.5.22.tar.gz

3.1.1解包

\[root@yangwenbo yang\]\# tar xf cmake-2.8.6.tar.gz -C /usr/src/

3.1.2去解包后的文件存放位置的目录

\[root@yangwenbo yang\]\# cd /usr/src/cmake-2.8.6/

3.1.3编译安装

\[root@yangwenbo cmake-2.8.6\]\# ./configure && gmake && gmake install

\#以下省略。。。

耐心等待...

3.1.4编译成功

\[root@Mysql cmake-2.8.6\]\# echo $?

3.2源码编译mysql-5.5.22.tar.gz

\[root@yangwenbo yang\]\# ls

cmake-2.8.6.tar.gz mysql-5.5.22.tar.gz

3.2.1创建程序用户

\[root@yangwenbo yang\]\# useradd -s /sbin/nologin -M mysql

\[root@yangwenbo yang\]\# id mysql

uid=500(mysql) gid=500(mysql) groups=500(mysql)

3.2.2解包

\[root@yangwenbo yang\]\# tar xf mysql-5.5.22.tar.gz -C /usr/src/

3.2.3去解包后的文件存放位置的目录

\[root@yangwenbo yang\]\# cd /usr/src/mysql-5.5.22/

3.2.4编译安装

\[root@yangwenbo mysql-5.5.22\]\# cmake -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -DDEFAULT\_CHARSET=utf8 -DDEFAULT\_COLLATION=utf8\_general\_ci -DWITH\_EXTRA\_CHARSETS=all && make && make install

\#以下省略。。。

![0e2abb54368b4a7f787570ff02d5a9ce.png][]

3.2.5编译成功

\[root@Mysql mysql-5.5.22\]\# echo $?

3.2.6目录简介

![22315be1825f21616845c67a48f0656a.png][]

4.安装后优化操作

4.1修改mysql安装目录的属主

\[root@Mysql /\]\# chown -R mysql /usr/local/mysql/

\[root@Mysql /\]\# ll -d /usr/local/mysql/

drwxr-xr-x. 13 mysql root 4096 Aug 19 00:19 /usr/local/mysql/

4.2创建修改my.cnf配置文件

\[root@Mysql mysql\]\# /bin/cp support-files/my-medium.cnf /etc/my.cnf

![e9de713a65868d2f7631cb680d4cf5d0.png][]

![4b551cea501ab0979b2be98f9729c168.png][]

4.3创建修改mysqld的启动脚本

\[root@Mysql mysql\]\# /bin/cp support-files/mysql.server /etc/init.d/mysqld

4.4为启动脚本加上X权限

\[root@Mysql mysql\]\# chmod +x /etc/init.d/mysqld

\[root@Mysql mysql\]\# ll -d /etc/init.d/mysqld

\-rwxr-xr-x. 1 root root 10650 Aug 19 01:08 /etc/init.d/mysqld

4.5添加至系统服务(开机自启动)

\[root@Mysql mysql\]\# chkconfig mysqld --add

\[root@Mysql mysql\]\# chkconfig mysqld --list

mysqld 0:off 1:off2:on3:on4:on5:on6:off

4.6.1使用软连接，使环境变量找到这个命令

\[root@Mysql mysql\]\# which mysql \#一开始找不到这个命令

/usr/bin/which: no mysql in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)

\[root@Mysql mysql\]\# ln -s /usr/local/mysql/bin/\* /usr/local/bin/

\[root@Mysql mysql\]\# which mysql \#通过软连接，已经可以找到这个命令

/usr/local/bin/mysql

4.6.2使用环境变量

![19aa0ad439dd0fb94822e012a013af10.png][]

![7bf412068baed4ceb23098de1edf9137.png][]

4.7执行mysql\_install\_db脚本初始化数据库

\[root@Mysql mysql\]\# /usr/local/mysql/scripts/mysql\_install\_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

\#以下省略。。。

4.8启动mysql服务，并查看运行状态

\[root@Mysql mysql\]\# /etc/init.d/mysqld start

Starting MySQL... SUCCESS!

\[root@Mysql mysql\]\# netstat -anpt | grep :3306

tcp 0 0 0.0.0.0:3306 0.0.0.0:\* LISTEN 40589/mysqld

5.登录MySQL

5.1进入

![c952161340305d601e74ca1ed7bf45a0.png][]

5.2MySQL参数

![a8e244b89bafcd90aaa741f4ab43c2f1.png][]

5.3为MySQL设置密码

\[root@Mysql mysql\]\# mysqladmin -uroot password '971108'

5.4用户登录

![1b16f5a4fc3ea723d6d6e547185a32cf.png][]

不交互登录

\[root@Mysql mysql\]\# mysql -uroot -p971108

Welcome to the MySQL monitor. Commands end with ; or \\g.

Your MySQL connection id is 2

Server version: 5.5.22-log Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.

mysql>

\#登录成功，配置完成

6.误删tmp目录下的文件

6.1已知误删tmp目录下的文件

![50b1c92820981940d6af430bc940e2c6.png][]

6.2修改MySQL配置文件

![955afe5cec07fbf48f14caa21a47192f.png][]

![be3698537b4fb5da79ac0ca7a0b5cfa8.png][]

6.3重启MySQL

![9d5566a1ea94a41957577e7e457a61fc.png][]

6.4查看

![59c562478f2d003b1038729d751d6eaf.png][]

[1aa8d3d2e556ea507f1288b33fc6802a.png]: /images/20221119/a7bfa2ade510473da47eb782f0a5e291.png
[0e2abb54368b4a7f787570ff02d5a9ce.png]: /images/20221119/f26cbdd802a047cfa4b08876a3b37d42.png
[22315be1825f21616845c67a48f0656a.png]: /images/20221119/8094efc482784b05a08e0f4570bfc85a.png
[e9de713a65868d2f7631cb680d4cf5d0.png]: /images/20221119/fe3a553627a540d98c8405400a547c00.png
[4b551cea501ab0979b2be98f9729c168.png]: /images/20221119/c86a3e8c2d1648debd576fad2cd47a3d.png
[19aa0ad439dd0fb94822e012a013af10.png]: /images/20221119/c646041120cb44bebdde21c2c8ba83dd.png
[7bf412068baed4ceb23098de1edf9137.png]: /images/20221119/027dcf95b7a54a05bdccbced93f67cd9.png
[c952161340305d601e74ca1ed7bf45a0.png]: /images/20221119/6f026d30b8da4e808248c1e6c8e3185d.png
[a8e244b89bafcd90aaa741f4ab43c2f1.png]: /images/20221119/245934306adb4be994551bcae72d0f26.png
[1b16f5a4fc3ea723d6d6e547185a32cf.png]: /images/20221119/e8ca42a056864027822b726ae29bfb89.png
[50b1c92820981940d6af430bc940e2c6.png]: /images/20221119/b8c012ac9f4e463eabed29c528e8dd2b.png
[955afe5cec07fbf48f14caa21a47192f.png]: /images/20221119/0483fa2b1f3d41acbea2d12c7ced556b.png
[be3698537b4fb5da79ac0ca7a0b5cfa8.png]: /images/20221119/b0325635a61c4e59be92ce88bc633bf2.png
[9d5566a1ea94a41957577e7e457a61fc.png]: /images/20221119/c58591e7771546ac8b06ea7508e9bbd9.png
[59c562478f2d003b1038729d751d6eaf.png]: /images/20221119/2b2ba4722f6545939a5a9feb3c4cc985.png