Liunx Redhat安装mysql

源码安装

先下载好源码包

https://downloads.mysql.com/archives/community/

创建目录

mkdir  /soft

 

将 mysql-boost-5.7.14.tar.gz 文件拖入虚拟机/soft目录中，然后进入/soft目录

首先在/etc/yum.repos.d/目录下新建一个Centos-8.repo的文件

touch /etc/yum.repos.d/Centos-8.repo

然后要编译该文件

vi /etc/yum.repos.d/Centos-8.repo

# CentOS-Base.repo
#
# The mirror system uses the connecting IP address of the client and the
# update status of each mirror to pick mirrors that are updated to and
# geographically close to the client.  You should use this for CentOS updates
# unless you are manually picking other mirrors.
#
# If the mirrorlist= does not work for you, as a fall back you can try the 
# remarked out baseurl= line instead.
#
#
 
[base]
name=CentOS-$releasever - Base - mirrors.aliyun.com
failovermethod=priority
baseurl=https://mirrors.aliyun.com/centos/$releasever/BaseOS/$basearch/os/
        http://mirrors.aliyuncs.com/centos/$releasever/BaseOS/$basearch/os/
        http://mirrors.cloud.aliyuncs.com/centos/$releasever/BaseOS/$basearch/os/
gpgcheck=1
gpgkey=https://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-Official
 
#additional packages that may be useful
[extras]
name=CentOS-$releasever - Extras - mirrors.aliyun.com
failovermethod=priority
baseurl=https://mirrors.aliyun.com/centos/$releasever/extras/$basearch/os/
        http://mirrors.aliyuncs.com/centos/$releasever/extras/$basearch/os/
        http://mirrors.cloud.aliyuncs.com/centos/$releasever/extras/$basearch/os/
gpgcheck=1
gpgkey=https://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-Official
 
#additional packages that extend functionality of existing packages
[centosplus]
name=CentOS-$releasever - Plus - mirrors.aliyun.com
failovermethod=priority
baseurl=https://mirrors.aliyun.com/centos/$releasever/centosplus/$basearch/os/
        http://mirrors.aliyuncs.com/centos/$releasever/centosplus/$basearch/os/
        http://mirrors.cloud.aliyuncs.com/centos/$releasever/centosplus/$basearch/os/
gpgcheck=1
enabled=0
gpgkey=https://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-Official
 
[PowerTools]
name=CentOS-$releasever - PowerTools - mirrors.aliyun.com
failovermethod=priority
baseurl=https://mirrors.aliyun.com/centos/$releasever/PowerTools/$basearch/os/
        http://mirrors.aliyuncs.com/centos/$releasever/PowerTools/$basearch/os/
        http://mirrors.cloud.aliyuncs.com/centos/$releasever/PowerTools/$basearch/os/
gpgcheck=1
enabled=0
gpgkey=https://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-Official


[AppStream]
name=CentOS-$releasever - AppStream - mirrors.aliyun.com
failovermethod=priority
baseurl=https://mirrors.aliyun.com/centos/$releasever/AppStream/$basearch/os/
        http://mirrors.aliyuncs.com/centos/$releasever/AppStream/$basearch/os/
        http://mirrors.cloud.aliyuncs.com/centos/$releasever/AppStream/$basearch/os/
gpgcheck=1
gpgkey=https://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-Official

 

接下来安装开发工具和开发包

yum install -y cmake gcc-c++* make ncurses-devel
yum install libaio libaio-devel openssl-devel -y
yum install perl-Data-Dumper -y
yum install net-tools vim -y
 

然后解压文件

cd /soft/ 

tar xf mysql-boost-5.7.14.tar.gz -C /usr/local/src/

然后为mysql 创建户和组

groupadd -r -g 306 mysql
useradd -g 306 -r -u 306 mysql

接下来进入文件的目录下

cd /usr/local/src/mysql-5.7.14/

然后一条条复制下面代码

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DMYSQL-USER=mysql \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=./boost

接着进行下载

make -j 4 && make install

然后更改文件夹属组

chown -R mysql.mysql /usr/local/mysql/

接着进行初始Mysql

/usr/local/mysql/bin/mysqld --initialize \
--user=mysql --datadir=/usr/local/mysql/data \
--basedir=/usr/local/mysql/

 

然后为mysql 提供主配置文件

cd /usr/local/mysql/
\cp support-files/my-default.cnf /etc/my.cnf

vim /etc/my.cnf
[mysqld]
datadir = /usr/local/mysql/data

 

为mysql 提供sysv服务

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on 

然后修改path环境变量，让系统使用MySQL的命令

vim /etc/profile.d/mysql.sh
export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile.d/mysql.sh

这样就🆗了

启动mysql

systemctl start mysqld

 

重新进入mysql

mysql -uroot -p

输入之前给出的密码

进行修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

 

 

 

yum安装

用centos-8.repo（https://wwa.lanzous.com/ihARSndnpnc）替换掉/etc/yum.repos.d/redhat.repo这个文件

 

yum clean all
yum makecache
yum repolist 

然后创建soft 文件夹，安装源安装进去。

cd /soft/

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum install -y mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql-community-server

 

登录mysql

mysql -u root -p

输入之前给出的随机密码即可进入

记得要修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码'

 

这样就好啦