mysql5.7编译安装过程
mkdir - p/数据/{mysql、}
下载mysql5.7源码包cd/usr/local/src
https://dev.mysql.com/get/downloads/mysql wget - 5.7 -/- mysql - 5.7.22.tar.gz
tar xf mysql-5.7.22.tar。广州
下载增加
wget http://www.sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz
焦油-zxvf boost_1_59_0.tar。广州- c/usr/local
mv/usr/local/boost_1_59_0/usr/local/boost
#安装
yum - y groupinstall“发展tools"
yum - y安装wget iproute iotop地铁穿孔telnet dstat iftop vim cmake gcc gcc-c + +野牛ncurses ncurses-devel
yum - y安装,libxml2 libxml2-devel openssl-devel bzip2 bzip2-devel libcurl-devel libjpeg libjpeg-devel libpng-devel libicu-devel libmcrypt-devel freetype-devel libtidy libtidy-devel ImageMagick-devel mhash mhash-devel pcre-devel libzip postgresql-devel
groupadd - g 306 mysql
useradd mysql - u 306 - g - s/sbin/nologin - m mysql
mkdir/数据/mysql pv
乔恩- r mysql。mysql/数据/mysql
cmake -DCMAKE_INSTALL_PREFIX=/usr/地方/mysql -DMYSQL_DATADIR=/数据/mysql -DWITH_BOOST=/usr/地方/提高-DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1=1 -DENABLE_DTRACE=0 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EMBEDDED_SERVER=1
做,,使安装
#设置权限
乔恩- r mysql: mysql/数据/mysql
添加配置文件
vim/etc/my.cnf
(mysqld)端口=3306
basedir=/usr/地方/mysql
datadir=/数据/mysql
character-set-server=utf8
default-storage-engine=InnoDB
max_connections=5120
query_cache_size=0
tmp_table_size=18 m
日志错误=/数据/mysql/mysql-error。日志
thread_cache_size=8
myisam_sort_buffer_size myisam_max_sort_file_size=64克=35 m
key_buffer_size=25 m
read_buffer_size=64 k
read_rnd_buffer_size=256 k
sort_buffer_size=256 k
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1通过innodb_buffer_pool_size=47 m m
innodb_log_file_size=24 m
innodb_thread_concurrency=8
初始化mysql
/usr/地方/mysql/bin/mysqld initialize-insecure——用户=mysql——basedir=/usr/地方/mysql——datadir=/数据/mysql
添加mysql环境变量
回声“出口路径=/usr/地方/mysql/bin: PATH"美元;在比;源/etc/profile/etc/profile
导出头文件
ln sv/usr/local/mysql/include/usr/include/mysqld
导出库文件
回声“/usr/地方/mysql/lib"比;/etc/ld.so.conf.d/mysql。参看
ldconfig
添加启动脚本
cp/usr/local/mysql/support-files/mysql。服务器/etc/init.d/mysqld
chmod + x/etc/init.d/mysqld
chkconfig——添加mysqld
启动服务,启动服务之后可以直接无码密码登录,如果无法登录继续下面两步
/etc/init。d/mysqld开始
找到mysql5.7的初始密码
grep“临时password"/数据/mysql/mysql-error.log
2018 - 09 - 25 - t06:30:28.930040z 1[注]root@localhost生成一个临时密码:Ui4/OupkjroO
修改密码
mysql -uroot -pUi4/OupkjroO
mysql>改变用户root@localhost被& # 39;yourpassword& # 39;;