mysql rpm安装及源码安装

梦里梦外; 2022-02-20 01:01 293阅读 0赞

**rpm安装**  
1.需要先卸载mariadb

rpm -e   mariadb-libs  5.5.56-2.el7.x86_64

下载mysql的repo源

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

安装mysql-community-release-el7-5.noarch.rpm包

$ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

安装这个包后，会获得两个mysql的yum repo源：/etc/yum.repos.d/mysql-community.repo，/etc/yum.repos.d/mysql-community-source.repo。

2.在官网下载Mysql-5.6.32-1.l7.x86\_64.rpm-bndle.tar  
解压

tar -xf  Mysql-5.6.32-1.l7.x86_64.rpm-bndle.tar

3.安装

yum  install   Mysql-client-5.6.32-1.l7.x86_64.rpm
    yum   install    Mysql-server-5.6.32-1.l7.x86_64.rpm

4.初始化：

/usr/bin/mysql_install_db --user=mysql --datadir=/var/lib/mysql &
    cd /usr ; /usr/bin/mysqld_safe &

如果出错  
FATAL ERROR: please install the following Perl modules before executing /usr/bin/mysql\_install\_db:Data::Dumper

yum install perl-Data-Dumper -y

5.安全设置

/usr/bin/mysql_secure_installation    //设置密码

6.开启服务  
systemctrl start mysqld  
systemctrl enable mysql

**源码安装：**  
从5.5之后开始使用cmake编译  
1.安装开发工具和开发包

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

2.编译安装mysql  
1)从官网下载安装包mysql-5.6.32.tar.gz

tar -xf mysql-5.6.32.tar.gz -C /usr/local/src/

2)使用cmake编译

cd /usr/local/src/mysql-5.6.32
    cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
    -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc \
    -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 \
    -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 \
    -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 \
    -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
    -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all \
    -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci \
    -DWITH_DEBUG=0 -DENABLE_PROFILING=1 -DENABLE_DOWNLOADS=1

如果编译出错需要清空之前的编译数据  
make clean ; rm CMakeCache.txt

编译完成之后

编译 & 安装

make
    make install

这两部都需要很长时间耐心等待

3、初始化  
创建用户

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

创建数据库存放目录并授权

mkdir /usr/local/mysql/data -p
      chown -R mysql.mysql /usr/local/mysql/data

初始化mysql

/usr/local/mysql/scripts/mysql_install_db --user=mysql  --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql/

4.为mysql提供主配置文件

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

5.为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

6、修改PATH环境变量，让系统可以直接使用mysql的相关命令

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

7.启动MySQL：

systemctl start mysql