mysql版本:5.6.38.tar.gz (generic版)
提示:编译安装之前先创建mysql用户和组(此步骤略过)
1. 安装依赖包
yum install libaio-devel ncurses-devel cmake gcc gcc-c++ bison -y
2. 用cmake编译
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/data/mysql \
-DMYSQL_DATADIR=/usr/local/data/mysql/data \
-DSYSCONFDIR=/usr/local/data/mysql \
-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=1
3. 编译完成后开始安装
make
make install
4. 修改mysql目录权限
chown -R mysql.mysql /usr/local/data/mysql
5. 数据库初始化
cd /usr/local/data/mysql
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/mnt/mysqldata --
pid-file=/usr/local/mysql/mysql.pid --tmpdir=/tmp
6. 拷贝并修改配置文件
cp support-files/my-default.cnf /etc/my.cnf
vim /etc/my.cnf
[mysqld] 添加:
log_bin=/var/mysql/bin_log //binlog日志存放路径
log-error=/usr/local/mysql/error.log
basedir=/usr/local/mysql
datadir=/mnt/mysqldata
socket=/tmp/mysql.sock
pid-file=/usr/local/mysql/mysql.pid
user=mysql
tmpdir=/tmp
7. 设置环境变量
vim /root/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/data/mysql/bin:/usr/local/data/mysql/lib
[root@localhost ~]#source /root/.bash_profile //使刚才的修改生效
8. 制作成服务启动
cp support-files/mysql.server /etc/init.d/mysql
相关命令:
service mysql start
service mysql stop
service mysql restart
9设置开机启动mysql服务(略过)