编译安装mysql5.6
首先检查机器mysql
rpm -qa|grep -i mysql
删除相关mysql内容:
yum remove 上面查出来的相关信息
yum -y install make gcc-c++ cmake bison-devel ncurses-devel
[root@localhost mysql-5.6.35]# cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
Centos7操作 编译安装mysql5.7 需要安装boost
-DCMAKE_INSTALL_PREFIX=/data/service/Mysql/mysql \
-DMYSQL_DATADIR=/data/service/Mysql/mysql/data/ \
-DMYSQL_UNIX_ADDR=/data/service/Mysql/mysql/data/mysql.sock \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DWITH_MEMORY_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/data/service/boost_1_59_0 \
-DDEFAULT_COLLATION=utf8_general_ci
注意:还会生成一个随机数据库密码
[root@localhost mysql-5.6.35]# make && make install
[root@localhost mysql-5.6.35]# make clean
8、设置权限
查看是否有mysql用户及用户组
[root@localhost mysql-5.6.35]# cat /etc/passwd
[root@localhost mysql-5.6.35]# cat /etc/group
如果没有就添加mysql用户和组
[root@localhost mysql-5.6.35]# groupadd mysql
[root@localhost mysql-5.6.35]# useradd -g mysql mysql
修改/usr/local/mysql权限
[root@localhost mysql-5.6.35]# chown -R mysql:mysql /usr/local/mysql
9、初始化配置
进入安装路径
[root@localhost mysql-5.6.35]# cd /usr/local/mysql
执行初始化配置脚本,创建系统自带的数据库和表
[root@localhost mysql]# scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
10、启动MySQL
添加服务,拷贝服务脚本到init.d目录
如果/etc目录有之前存在的my.cnf文件,将其重命名。启动MySQL服务时,会优先在/etc目录下查找
[root@localhost mysql]# mv /etc/my.cnf /etc/my.cnf.bak
[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysql
[root@localhost mysql]# chkconfig mysql on
[root@localhost mysql]# service mysql start --启动MySQL