cmake编译安装mysql-5.7.9

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

#cat /proc/version
CentOS Linux release 8.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=/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=/opt/mysql/bin:$PATH' >>/etc/profile
# source /etc/profile

初始化数据库

# MySQL 5.6初始化数据库的命令：
# /usr/local/mysql/scripts/mysql_install_db --basedir=/opt/mysql --datadir=/opt/mysql/data -user=mysql

# MySQL 5.7初始化数据库的命令：
# /opt/mysql/bin/mysqld --initialize-insecure --basedir=/opt/mysql --datadir=/opt/mysql/data -user=mysql

拷贝启动服务脚本

# cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld
# chmod 700 /etc/init.d/mysqld

修改配置文件

# vim /etc/my.cnf
[mysqld]
server_id=1
port=3306
basedir=/opt/mysql
datadir=/opt/mysql/data
socket=/opt/lib/mysql.sock 
log_bin=/opt/mysql/mysql-bin
log_error=/opt/mysql/log/mysql.log
character-set-server=utf8

[client]
socket=/opt/mysql/mysql.sock
# /etc/init.d/mysqld start

 设置开机启动

#cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld
#chmod 700 /etc/init.d/mysqld
#chkconfig --add mysqld
#chkconfig mysqld on

 

#修改root密码
进入mysql库

use mysql;
update user set authentication_string=PASSWORD('newpassword') where user='root';

flush privileges;

 

#快速设置密码

mysqladmin -u root password 'newpassword'