linux下的MySQL安装

linux下的MySQL安装

下载地址

https://dev.mysql.com/downloads/mysql/5.7.html#downloads

目录

        RPM方式进行安装

        源码方式进行安装

rpm包安装

1.解压缩

$ tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar

2.移除本身自带的mariadb分支

$ yum remove -y mariadb-libs-5.5.60-1.el7_5.x86_64 mysql-libs

3.安装客户端

 $ rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm
 $ rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm
 $ rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm

4.安装服务端

  $ yum install -y net-tools perl
  $ rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm

5.启动mysql

  $ systemctl start mysqld

6.从日志中摘取MySQL默认密码

  $ cat /var/log/mysqld.log | grep password

7.修改root密码

  $ ALTER USER root@'localhost' IDENTIFIED BY 'Abcde@123';

源码方式进行安装

1.下载MySQL源码和bootst库文件

 $ wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20.tar.gz
 $ wget https://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

2.安装编译工具

 $ yum install -y git  cmake   gcc   gcc-c++  bison   ncurses   ncurses-devel bison-devel  libaio-devel

3.创建mysql根目录和数据目录

 $ mkdir -p /usr/local/mysql
 $ mkdir -p /usr/local/mysql/data 

4.解压缩

 $ tar -zxvf mysql-5.7.24-el7-x86_64.tar.gz && mv mysql-5.7.24-el7-x86_64/* /usr/local/mysql

5.添加mysql用户和mysql用户组

 $ groupadd -r mysql
 $ useradd -r -g mysql -s /sbin/nologin mysql

6.给mysql用户指定文件夹

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

7.生成makefile

 $ cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \   
	-DMYSQL_DATADIR=/usr/local/mysql/data \  
	-DWITH_BOOST=/usr/local/boost_1_59_0 \  
	-DSYSCONFDIR=/etc \    
	-DENABLED_LOCAL_INFILE=1 \  
	-DEXTRA_CHARSETS=all  

8.编译安装，单线程大概需要1个小时

$ make -j `grep processor /proc/cpuinfo | wc -l`
$ make install

9.MySQL初始化

$ /usr/local/mysql/bin/mysqld --initialize --user=mysql

10.转移mysqld文件

$ cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld