mysql includes boost headers_MySQL 5.7.15 编译安装

2.下载MySQL源代码，选择下载Generic Linux (Architecture Independent), Compressed TAR Archive Includes Boost Headers版本，该版本包含boost库信息，不需要单独下载[root@oel6 local]# wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.15.tar.gz3.添加mysql用户[root@oel6 local]# groupadd mysql

[root@oel6 local]# useradd -r -g mysql -s /bin/nologin mysql4.解压MySQL安装介质[root@oel6 local]# tar -zxvf mysql-boost-5.7.15.tar.gz

[root@oel6 local]# cd mysql-5.7.15/5.编译安装MySQL[root@oel6 local]# mkdir -p /mysql/data

[root@oel6 local]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mysql/data -DWITH_BOOST=/usr/local/mysql-5.7.15/boost/boost_1_59_0

[root@oel6 mysql-5.7.15]# make

[root@oel6 mysql-5.7.15]# make install清除编译错误信息[root@oel6 mysql-5.7.15]# make clean

[root@oel6 mysql-5.7.15]# rm CMakeCache.txt6.初始化MySQL数据库[root@oel6 ~]# cd /usr/local/mysql/

[root@oel6 mysql]# chown -R mysql:mysql ./

[root@oel6 mysql]# bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/mysql/data

2016-10-06T05:11:36.422748Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2016-10-06T05:11:36.832157Z 0 [Warning] InnoDB: New log files created, LSN=45790

2016-10-06T05:11:36.900930Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2016-10-06T05:11:36.961751Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 5b4533be-8b83-11e6-927a-0800279bbbbf.

2016-10-06T05:11:36.963090Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2016-10-06T05:11:36.964712Z 1 [Note] A temporary password is generated for root@localhost: ;uIY2:ZVrv)u[root@oel6 mysql]# bin/mysql_ssl_rsa_setup --datadir=/mysql/data

Generating a 2048 bit RSA private key

......+++

.........................................................................................................+++

writing new private key to 'ca-key.pem'

-----

Generating a 2048 bit RSA private key

...........................+++

............................................................................................................................................................................................+++

writing new private key to 'server-key.pem'

-----

Generating a 2048 bit RSA private key

.................+++

...........................................................................................................................+++

writing new private key to 'client-key.pem'

-----MySQL 5.7.6 之前版本，使用下面命令进行初始化

bin/mysql_install_db --user=mysql7.启动MySQL数据库 (编译安装的MySQL，会默认创建/etc/my.cnf文件)[root@oel6 ~]# cd /mysql

[root@oel6 mysql]# mkdir log

[root@oel6 mysql]# mkdir run

[root@oel6 ~]# chown -R mysql:mysql /mysql

[root@oel6 mysql]# cat /etc/my.cnf

[mysqld]       //非默认参数会影响通过服务方式启停数据库datadir=/mysql/data

user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

[mysqld_safe][root@oel6 mysql]# bin/mysqld_safe --user=mysql &

[1] 27572

[root@oel6 mysql]# 2016-10-06T05:21:00.684235Z mysqld_safe Logging to '/mysql/log/mysqld.log'.

2016-10-06T05:21:00.709272Z mysqld_safe Starting mysqld daemon with databases from /mysql/data8.登陆MySQL数据库[root@oel6 ~]# vi /root/.bash_profile

PATH=$PATH:$HOME/bin:/usr/local/mysql/bin //环境变量中增加mysql的路径[root@oel6 ~]# . /root/.bash_profile

[root@oel6 mysql]# mysql -u root -h localhost -p

Enter password: ;uIY2:ZVrv)uWelcome to the MySQL monitor.  Commands end with ; or \g.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'oracle';9.配置MySQL服务自启动[root@oel6 ~]# cd /usr/local/mysql

[root@oel6 mysql]# cp support-files/mysql.server /etc/init.d/mysqld

[root@oel6 mysql]# chkconfig --add mysqld

[root@oel6 mysql]# chkconfig --list mysqld

mysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off10.关闭MySQL数据库[root@oel6 bin]# mysqladmin -u root shutdown

mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

[root@oel6 bin]# mysqladmin -u root -p shutdown

Enter password:

2016-10-06T05:50:46.469848Z mysqld_safe mysqld from pid file /mysql/run/mysqld.pid ended

[1]+  Done                    mysqld_safe --user=mysql11.通过服务进行MySQL启停[root@oel6 bin]# service mysqld start

Starting MySQL.                                            [  OK  ]

[root@oel6 bin]# service mysqld stop

Shutting down MySQL.                                       [  OK  ]12.登陆非默认端口MySQL[root@oel6 bin]# mysql -u root -P8000 -h localhost -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

MySQL 5.7.15 编译安装

标签：denied   error:   sel   and   parent   safe   been   support   etc

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://blog.51cto.com/recyclebin/2067569