cmake安装mysql5.7_cmake编译安装mysql-5.7.9

查看当前操作系统版本信息

#cat /proc/version

CentOS Linux release8.1.1911 (Core)

安装必须的工具和库

#yum install ncurses-devel libaio-devel -y

#yum install cmake gcc gcc-c++ make autoconf -y

创建系统用户

#groupadd -r mysql

#useradd-r -g mysql -s /sbin/nologin mysql

下载解压tar.gz包

#wget https://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.38.tar.gz

#tar-zxvf mysql-5.6.38.tar.gz

配置解析

#cd mysql-5.6.38

#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii -DENABLED_LOCAL_INFILE=ON -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=0 -DWITH_FAST_MUTEXES=1 -DWITH_ZLIB=bundled -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DWITH_DEBUG=0

编译安装

# make && make install

环境变量、mysql目录的用户和用户组

# chown -R mysql:mysql /usr/local/mysql/

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

# source /etc/profile

初始化数据库

# MySQL 5.6初始化数据库的命令：

#/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data -user=mysql

# MySQL5.7初始化数据库的命令：

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

拷贝启动服务脚本

# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

# chmod700 /etc/init.d/mysqld

修改配置文件

# vim /user/local/mysql/my.cnf

[mysqld]

server_id=1port=3306basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

socket=/usr/local/mysql/mysql.sock

log_bin=/usr/local/mysql/mysql-bin

log_error=/var/log/mysql.log

character-set-server=utf8

[client]

socket=/usr/local/mysql/mysql.sock

#/etc/init.d/mysqld start

设置开机启动

重置管理员密码