mysql5.7编译安装

87898

mysql5.7编译安装
mkdri /home/data
cd /home/data
rz 软件包（yum install lrzsz）
mysql-boost-5.7.15.tar.gz
mysql-5.7.15.tar.gz
cmake-3.5.2.tar.gz

预装软件：
yum install -y make gcc gcc-c++
yum install -y ncurses-devel
yum intsall -y bison bison-devel
yum install -y openssl openssl-devel

安装cmake
wget https://cmake.org/files/v3.5/cmake-3.5.2.tar.gz

# tar xf cmake-3.5.2.tar.gz
# cd cmake-3.5.2
# ./bootstrap
# gmake
# gmake install

Boost库放到预装位置
wget http://sourceforge.net/projects/ ... boost_1_59_0.tar.gz
# tar xzvf boost_1_59_0.tar.gz(别的版本报错,也可以mysql官网下载mysql-boost-5.7.15.tar.gz 包)

编译安装mysql
mkdir -p /usr/local/mysql
mkdir -p /home/data/mysqldb
useradd mysql
cd /home/data
chown -R mysql:mysql mysqldb

tar -xzvf mysql-5.7.15.tar.gz
tar -xzvf mysql-boost-5.7.15.tar.gz
cd mysql-5.7.15
如果想清理此前的编译所生成的文件，则需要使用如下命令：
make clean
rm CMakeCache.txt

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/home/data/mysqldb \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DWITH_LIBWRAP=0 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DWITH_SSL=system \
-DWITH_ZLIB=system \
-DWITH_BOOST=/home/data/mysql-5.7.15/boost \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci



make
make install



/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/home/data/mysqldb

“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
–datadir目标目录下不能有数据文件


mysql的服务脚本


#拷贝脚本
cp support-files/mysql.server /etc/init.d/mysqld
#赋予权限
chmod +x /etc/init.d/mysqld
#增加至sysV服务
chkconfig --add mysqld
#开机自启动
chkconfig mysqld on


修改/usr/local/mysql权限

chmod +w /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql
启动数据库

service mysqld start

添加环境变量
修改 /etc/profile
末尾追加：export PATH=$PATH:/usr/local/mongodb/bin:/usr/local/mysql/bin

echo 'export PATH=$PATH:/usr/local/mongodb/bin:/usr/local/mysql/bin' >>/etc/profile

source /etc/profile

dbrootpwd=oneinstack  #数据库root密码
/usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@'127.0.0.1' identified by \"$dbrootpwd\" with grant option;"
/usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@'localhost' identified by \"$dbrootpwd\" with grant option;"

set password for root@localhost = password('123456');

create user zheng;
update user set authentication_string=password("123456") where user="zheng";
grant all on zheng.* to 'zheng'@'10.116.39.147';
create user text;
update user set authentication_string=password("123456") where user="text";
grant all on text.* to 'text'@'localhost';
3.刷新数据库 （一定要记得刷新）
mysql>flush privileges