mysql5.7编译安装

发表于 | 分类于
本文字数： 1.9k | 阅读时长 ≈ 2 分钟
编译安装
yum remove mariadb
yum -y install gcc gcc-c++ ncurses ncurses-devel cmake 
wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
wget http://files.directadmin.com/services/all/mysql/5.7/5.7.20/mysql-5.7.20.tar.gz
useradd -M -s /sbin/nologin  mysql
tar zxvf boost_1_59_0.tar.gz 
tar zxvf mysql-5.7.20.tar.gz 
mkdir -p /opt/laohulab/mysql-5.7.20/data
cd mysql-5.7.20/
cmake . -DCMAKE_INSTALL_PREFIX="/opt/laohulab/mysql-5.7.20" -DMYSQL_DATADIR="/opt/laohulab/mysql-5.7.20/data" -DDOWNLOAD_BOOST=1 -DWITH_BOOST=../boost_1_59_0 -DSYSCONFDIR=/opt/laohulab/mysql-5.7.20 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_EMBEDDED_SERVER=0
配置系统服务
cp /opt/laohulab/mysql-5.7.20/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list mysqld
启动服务
/opt/laohulab/mysql-5.7.20/bin/mysqld --initialize-insecure --user=mysql --basedir=/opt/laohulab/mysql-5.7.20 --datadir=/opt/laohulab/mysql-5.7.20/data
touch /opt/laohulab/mysql-5.7.20/mysql-error.log
chown -R mysql.mysql /opt/laohulab/mysql-5.7.20/
/opt/laohulab/mysql-5.7.20/bin/mysqld_safe --defaults-file="/opt/laohulab/mysql-5.7.20/my.cnf" &
创建数据库
CREATE DATABASE `tonnydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
权限
grant all privileges on tonnydb.* to 'tonny'@'%' identified by Welcome2018@';
flush privileges;
修改密码
/opt/laohulab/mysql-5.7.20/bin/mysql -uroot -p
 
select host,user,authentication_string from user;
UPDATE user SET authentication_string=PASSWORD('newpassword') WHERE user='root';
flush privileges;
参考

http://www.360doc.com/content/15/0629/17/14900341_481504365.shtml centos7

0%