centos7源码安装mysql5.7

待我称王封你为后i 2022-07-12 10:54 194阅读 0赞

**1.基础环境**  
$ yum install gcc gcc-c++   
$ yum install ncurses ncurses-devel   
$ yum install bison libgcrypt perl cmake

**2.创建用户**  
$ cat /etc/group | grep mysql     //查看是否存在mysql用户组  
$ cat /etc/passwd | grep mysql    //查看是否存在mysql用户  
$ groupadd mysql                  //创建用户组  
$ useradd -r -g mysql mysql       //创建用户

**3.创建目录,并赋予权限**  
$ mkdir /usr/local/mysql  
$ mkdir /usr/local/mysql/data  
$ mkdir /usr/local/mysql/logs  
$ mkdir /usr/local/mysql/pids  
$ chown -R mysql:mysql /usr/local/mysql

**4.mysql5.7源码编译需要boost库支持**  
4.1 检查和卸载已存在的boost库  
$ rpm -qa | grep boost  
$ yum -y remove boost-\*  
4.2 下载boost库，指定要1.59版本  
$ wget -S https://jaist.dl.sourceforge.net/project/boost/boost/1.59.0/boost\_1\_59\_0.zip  
4.3 解压库   
$ mkdir /usr/local/boost  
$ unzip boost\_1\_59\_0.zip  
$ mv boost\_1\_59\_0 /usr/local/boost/

**5.下载mysql5.7源码包**  
wget -S http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17.tar.gz

**6.编译，会比较漫长**  
$ tar xvf mysql-5.7.17.tar.gz  
$ cd mysql-5.7.17  
$ cmake . \\  
\-DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql \\  
\-DMYSQL\_DATADIR=/usr/local/mysql/data \\  
\-DDEFAULT\_CHARSET=utf8 \\  
\-DDEFAULT\_COLLATION=utf8\_general\_ci \\  
\-DMYSQL\_TCP\_PORT=3306 \\  
\-DMYSQL\_USER=mysql \\  
\-DWITH\_BOOST=/usr/local/boost/boost\_1\_59\_0  
$ make  
$ make install

**7.编辑配置文件my.cnf**  
$ mv /etc/my.cnf /etc/my.cnf.bak  
$ cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf  
$ vim /etc/my.cnf  
内容如下：

[mysqld]
    datadir=/usr/local/mysql/data
    socket=/usr/local/mysql/mysql.sock
    log-error=/usr/local/mysql/logs/mysqld.log
    pid-file=/usr/local/mysql/pids/mysqld.pid

如果有，删除这一行

# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

**8.初始化**  
$ cd /usr/local/mysql  
$ bin/mysqld --defaults-file=/etc/my.cnf --initialize-insecure --user=mysql  
$ ls data  
  
**9.配置启动服务与设置开机启动**  
$ cd /usr/local/mysql  
$ cp support-files/mysql.server /etc/init.d/mysqld  
$ chmod a+x /etc/init.d/mysqld  
  
$ chkconfig --list  
$ chkconfig --add mysqld  
$ chkconfig mysqld on  
$ chkconfig --list  
  
**10.设置mysql的环境变量**  
$ vim /etc/profile  
输入内容：

#mysql path
    export PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH

使环境变量生效：  
$ source /etc/profile  
  
**11.控制mysql**  
$ service mysqld start //启动  
$ service mysqld restart //重启  
$ service mysqld stop //停止  
  
**12.启动mysql后，设置mysql初始密码，只允许root在本机执行**  
$ mysql -uroot -h127.0.0.1  
$ use mysql;  
$ update user set authentication\_string=password('root') where user='root' and Host='localhost';  
$ FLUSH PRIVILEGES;  
  
**13.查看与设置防火墙**  
查看防火墙：  
$ firewall-cmd --list-port  
$ firewall-cmd --zone=public --list-ports  
  
开放防火墙端口：  
$ firewall-cmd --zone=public --add-port=3306/tcp --permanent  
$ firewall-cmd --reload  
  
**14.新增用户，如有需要**  
$ GRANT select, insert, update, delete, create, drop, alter ON \*.\* TO 'daiyu'@'%' IDENTIFIED BY 'daiyu' WITH GRANT OPTION;  
$ FLUSH PRIVILEGES;

参考官网教程：[https://dev.mysql.com/doc/refman/5.7/en/source-installation.html][https_dev.mysql.com_doc_refman_5.7_en_source-installation.html]

原文出自：[http://blog.csdn.net/daiyudong2020/article/details/56307532][http_blog.csdn.net_daiyudong2020_article_details_56307532]

End;

[https_dev.mysql.com_doc_refman_5.7_en_source-installation.html]: https://dev.mysql.com/doc/refman/5.7/en/source-installation.html
[http_blog.csdn.net_daiyudong2020_article_details_56307532]: http://blog.csdn.net/daiyudong2020/article/details/56307532