CentOS7安装MySql5.6（源码安装）

╰+哭是因爲堅強的太久メ 2021-11-29 06:06 486阅读 0赞

### 一、先卸载旧版本（如果已经安装） ###

1）、检查是否有安装

rpm -qa | grep mysql

2）、卸载

rpm -e mysql -libs

如果有依赖无法删除加上--nodeps强制删除

### 二、安装MySql ###

1)、安装编译代码需要的包

yum -y install make gcc c++ cmake bison-devel ncurse-devel
    
    #yum install gcc-c++
    #yum install ncurses-devel
    #yum install bison

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70][]

2)、下载上传mysql源码安装包并上传到/opt目录

![20190721141647853.png][]

3）、解压安装包

tar xvf mysql-5.6.14.tar.gz

4）、编译源码

cd mysql-5.6.14

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_ST0RAGE_ENGINE=1 -DWITH_INN0BASE_ST0RAGE_ENGINE=1 -DWUH_MEM0RY_ST0RAGE_ENGINE=1-DWITH_READUNE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306  -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 1][]

5）、编译安装

make && make install

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 2][]

###  三、配置MySql ###

1)、查看是否有mysql用户列表

cat /etc/passwd

2）、查看是否有mysql用户组

cat /etc/group

3)、创建mysql用户组

groupadd mysql

4）、创建mysql用户分配到mysql组

useradd -g mysql mysql

5）、修改/user/local/mysql用户和用户组权限

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

6）、初始化配置

进入安装目录

cd /usr/local/mysql

执行初始化脚本

注意：

从 MySQL 5.7.6 开始，[mysql\_install\_db][mysql_install_db]已被弃用，因为它的功能已集成到 MySQL 服务器[mysqld][]中。要初始化 MySQL 安装，请使用[\--initialize][--initialize]或[\--initialize-insecure][--initialize-insecure]选项调用[mysqld][]。

scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --collation-server=utf8_general_ci -DDefault-charset=utf8

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 3][]

7)、修改系统默认mysql配置文件为其他名字避免干扰我们自己的配置文件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 4][]

mv /etc/my.cnf /etc/my.cnf.bak

8）、启动MySql

拷贝服务器脚本到init.d目录，并设置开机启动(在/user/local/mysql下执行)

cp support-files/mysql.server /etc/init.d/mysql

修改 my.cnf编码集

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 5][]

设置mysql自启动

chkconfig mysql on #任何运行级别都自启动
    service mysql start  #启动服务

![20190721172749416.png][]

9）、修改root密码

进入bin目录

cd /usr/local/mysql/bin

进入数据库

./mysql -uroot

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 6][]

修改密码

mysql>SET PASSWORD=PASSWORD('root');

![20190721173836171.png][]

退出重新登入，需要密码才能登入

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 7][]

10）、配置mysql环境变量

编辑vim /etc/profile文件

vim /etc/profile

![20190721182652820.png][]

刷新配置文件

source /etc/profile

![20190721182947591.png][]

11）、配置mysql远程访问

防火墙开放3306端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent

重启防火墙

firewall-cmd --reload

登入mysql远程授权

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;

![20190721185427844.png][]

刷新配置

flush privileges;

![20190721185539507.png][]

测试远程连接

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 8][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70]: /images/20211129/faee868bae04479f91b8043e38182a35.png
[20190721141647853.png]: /images/20211129/f10b0ca648c543cbbcd960d123960f3f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 1]: /images/20211129/da2d7470bd56429c81cb8949bfede261.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 2]: /images/20211129/af9ec4c8e5e34742877ba8c887e1380f.png
[mysql_install_db]: https://www.docs4dev.com/docs/zh/mysql/5.7/reference/mysql-install-db.html
[mysqld]: https://www.docs4dev.com/docs/zh/mysql/5.7/reference/mysqld.html
[--initialize]: https://www.docs4dev.com/docs/zh/mysql/5.7/reference/server-options.html#option_mysqld_initialize
[--initialize-insecure]: https://www.docs4dev.com/docs/zh/mysql/5.7/reference/server-options.html#option_mysqld_initialize-insecure
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 3]: /images/20211129/0d6e7c8a67bb454eaf0a67fbeae36ff8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 4]: /images/20211129/b572c92fa72c47dcbaf51ccd86cbceb9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 5]: /images/20211129/5ca59a7d6b4b45c38adb92fe68c1aa90.png
[20190721172749416.png]: /images/20211129/b505c6ca9a614562ab7173944c96f34a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 6]: /images/20211129/e6cdf29c8aeb4df0b6edd973ad0162d8.png
[20190721173836171.png]: /images/20211129/a41cb94cf0c0459d8181d884a9bf9906.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 7]: /images/20211129/77c8c2a2c64649d097d3698263f0fed3.png
[20190721182652820.png]: /images/20211129/05356100e99e47229b0cfe5bc0d486a7.png
[20190721182947591.png]: /images/20211129/191c84d2488340bf8ff557f1a778c2b6.png
[20190721185427844.png]: /images/20211129/1162efc6e80a46e59fdef41296f266f1.png
[20190721185539507.png]: /images/20211129/a621f239643c416a83990694657e26a9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3htMzkzMzkyNjI1_size_16_color_FFFFFF_t_70 8]: /images/20211129/a0dad4ea6a36412dadf4fa86e398fdee.png