mysql-5.7.25登陆数据库命令_mysql5.7源码安装及常用命令

mysql5.7源码安装及常用命令

一、mysql安装

1.旧版本卸载

rpm -qa | grep "mariadb"

rpm -ev 软件包名称 --nodeps

2.安装依赖

yum -y install gcc gcc-c++ ncurses ncurses-devel cmake bison bison-devel

3.mysql下载

yum安装(可选)

yum install mariadb-server mariadb mariadb-libs -y

源码下载(推荐)

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.25.tar.gz

wget http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

tar -xzvf boost_1_59_0.tar.gz

tar -xzvf mysql-5.7.25.tar.gz

4.创建mysql用户

useradd -s /sbin/nologin mysql

mkdir -p /data/mysql

chown -R mysql:mysql /data/mysql

5.cmake编译安装

cd mysql-5.7.25

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DMYSQL_DATADIR=/data/mysql -DDOWNLOAD_BOOST=1 -DWITH_BOOST=../boost_1_59_0 -DSYSCONFDIR=/etc -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306 -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DWITH_EXTRA_CHARSETS=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_BIG_TABLES=1 -DWITH_DEBUG=0