mysql安装路径:/usr/local/mysql
mysql数据库路径: /data/mysql
mysql配置文件路径:/usr/local/mysql/my.cnf
# rpm -qa | grep mariadb
# rpm -e --nodeps mariadb-libs-5.5.37-1.el7_0.x86_64 Packet name is the last query that
创建用户组
groupadd mysql
创建用户
useradd -g mysql mysql -s / bin / false
Http://dev.mysql.com/downloads/mysql/5.7.html#downloads
Http://download.savannah.gnu.org/releases/libunwind/
Https://github.com/gperftools/gperftools/releases
# cd /usr/local/src/
# wget http://download.savannah.gnu.org/releases/libunwind/libunwind-1.1.tar.gz
# wget http://gperftools.googlecode.com/files/gperftools-2.5.tar.gz
# wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.x.tar.gz
# tar zxvf libunwind-1.1.tar.gz
# cd libunwind-1.1
# ./configure
# make
# make install
# cd ..
# tar zxvf gperftools-2.1.tar.gz
# cd gperftools-2.1
# ./configure
# make
# make install
# echo "/usr/local/lib" > /etc/ld.so.conf.d/usr_local_lib.conf
# ldconfig
# cd ..
# tar zxvf mysql-5.7.x.tar.gz
# cd mysql-5.7.x
在编译之前,使用如下命令来查看可用的编译参数描述
# cmake . -LH | more
如果编译出现错误,删除CMakeCache.txt重新编译
rm -rf CMakeCache.txt
开始编译:
# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DMYSQL_DATADIR=/data/mysql
-DSYSCONFDIR=/etc
-DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DENABLED_LOCAL_INFILE=1
-DMYSQL_UNIX_ADDR=/dev/shm/mysql.sock
-DMYSQL_TCP_PORT=3306
-DMYSQL_USER=mysql
-DWITH_DEBUG=0
-DDOWNLOAD_BOOST=1
-DWITH_BOOST=/usr/local/boost
# make
# make install
```
change permission
```
# chmod 755 /var/lib/mysql
# cd /usr/local/mysql
# chown -R mysql:mysql .
/usr/local/mysql/bin/mysqld --initialize --basedir=/usr/local/mysql --datadir=/data/mysql --user=mysql --explicit_defaults_for_timestamp=1
创建一个mysql配置文件
# cp support-files/my-default.cnf /usr/local/mysql/my.cnf