安装过程
准备
关闭防火墙和SElinux
简单:
关闭防火墙
systemctl stop firewalld
关闭SElinux
setenforce 0
添加阿里云yum源(非必要)
curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
安装阿里云yum扩展源(非必要)
curl -o /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo
安装wgt
yum -y install wget
安装编译工具
yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make glibcautomake autoconf cmake
开始
1.创建mysql用户
useradd -r mysql -M -s /bin/false
2.从官网下载tar包
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.27.tar.gz
创建mysql目录
mkdir -p /usr/local/mysql/{data,log}
解压
tar xzvf mysql-boost-5.7.27.tar.gz -C /usr/local/
编译安装
cd /usr/local/mysql-5.7.27/
cmake . \
-DWITH_BOOST=boost/boost_1_59_0/ \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DSYSCONFDIR=/etc \-DMYSQL_DATADIR=/usr/local/mysql/data \-DINSTALL_MANDIR=/usr/share/man \-DMYSQL_TCP_PORT=3306 \-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DEXTRA_CHARSETS=all \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_READLINE=1 \-DWITH_SSL=system \-DWITH_EMBEDDED_SERVER=1 \-DENABLED_LOCAL_INFILE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1
make
如果安装出错,想重新安装:
不用重新解压,只需要删除安装目录中的缓存文件CMakeCache.txt
make install
初始化
cd /usr/local/mysqlchown -R mysql.mysql ../bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data —初始化完成之后,一定要记住提示最后的密码用于登陆或者修改密码 (在最后一行)
修改配置文件
mv /etc/my.cnf /etc/my.cnf.bakvim /etc/my.cnf
[client]port = 3306socket = /tmp/mysql.sockdefault-character-set = utf8[mysqld]port = 3306user = mysqlbasedir = /usr/local/mysql #指定安装目录datadir = /usr/local/mysql/data #指定数据存放目录socket = /tmp/mysql.sockcharacter_set_server = utf8
启动mysql
/usr/local/mysql/bin/mysqld_safe --user=mysql &
登录mysql
/usr/local/mysql/bin/mysql -uroot -p(刚才记住的密码)
\q退出
cp support-files/mysql.server /etc/init.d/mysqldls -l /etc/init.d/mysqld
新加载系统服务,将MySQL数据库加入开机自启动
systemctl daemon-reloadchkconfig mysqld on
修改密码
/usr/local/mysql/bin/mysqladmin -uroot -p原始密码 password ‘你的密码’/usr/local/mysql/bin/mysql -uroot -p你的密码