Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL 5.7.9 source compiler installation instructions     - Ubuntu 14.04 to install file editor KKEdit 0.1.5 version (Linux)

- Good wireless network security information spread in the air (Linux)

- PHP interview questions of design patterns (Programming)

- 10 useful Linux command Interview Questions and Answers (Linux)

- Use SVN to automatically deploy code under Apache (Server)

- sed and awk in shell usage and some examples (Linux)

- Xmanager Remote Desktop login CentOS 6.5 (Linux)

- Linux kernel to achieve soft RPS network to receive soft interrupt load balancing to distribute (Linux)

- Linux, Eclipse flash back and reinstall the JDK methods (Linux)

- Difference Docker mirror and containers (Server)

- Into the Java keyword instanceof (Programming)

- Install the latest development version of Wine on RedHat and Debian-based systems (Linux)

- build Android environment on Ubuntu 12.04 (Server)

- FreeRadius installation process record (Linux)

- Basic Operation Linux files and directories (Linux)

- MyCAT separate read and write to achieve MySQL Practice (Database)

- Source code to compile and install MySQL 5.7.9 (Database)

- How to install the client sqlplus under linux (Database)

- MyCAT log analysis (Database)

- Protection Docker container Notice (Server)

 
         
  MySQL 5.7.9 source compiler installation instructions
     
  Add Date : 2017-08-31      
         
       
         
  First, explain the environment

1. Operating System

System Version: RHEL 6.3 X64

Operating system installation type: Basic

System installation package: gcc gcc-c ++ bzip2 (default) bzip2-devel bzip2-libs (default) python-devel ncurses-devel bison

1) gcc gcc-c ++

[Root @ mdb01 Packages] # rpm -ivh kernel-headers-2.6.32-279.el6.x86_64.rpm

warning: kernel-headers-2.6.32-279.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: kernel-headers ########################################### [100 %]

[Root @ mdb01 Packages] # rpm -ivh glibc-headers-2.12-1.80.el6.x86_64.rpm

warning: glibc-headers-2.12-1.80.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: glibc-headers ########################################### [100 %]

[Root @ mdb01 Packages] # rpm -ivh glibc-devel-2.12-1.80.el6.x86_64.rpm

warning: glibc-devel-2.12-1.80.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: glibc-devel ########################################### [100 %]

[Root @ mdb01 Packages] # rpm -ivh mpfr-2.4.1-6.el6.x86_64.rpm

warning: mpfr-2.4.1-6.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: mpfr ########################################### [100%]

[Root @ mdb01 Packages] # rpm -ivh cpp-4.4.6-4.el6.x86_64.rpm

warning: cpp-4.4.6-4.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: cpp ########################################### [100%]

[Root @ mdb01 Packages] # rpm -ivh ppl-0.10.2-11.el6.x86_64.rpm

warning: ppl-0.10.2-11.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: ppl ########################################### [100%]

[Root @ mdb01 Packages] # rpm -ivh cloog-ppl-0.15.7-1.2.el6.x86_64.rpm

warning: cloog-ppl-0.15.7-1.2.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: cloog-ppl ########################################### [100 %]

[Root @ mdb01 Packages] # rpm -ivh gcc-4.4.6-4.el6.x86_64.rpm

warning: gcc-4.4.6-4.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: gcc ########################################### [100%]

[Root @ mdb01 Packages] # rpm -ivh libstdc ++ - devel-4.4.6-4.el6.x86_64.rpm

warning: libstdc ++ - devel-4.4.6-4.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: libstdc ++ - devel ########################################### [100 %]

[Root @ mdb01 Packages] # rpm -ivh gcc-c ++ - 4.4.6-4.el6.x86_64.rpm

warning: gcc-c ++ - 4.4.6-4.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: gcc-c ++ ########################################### [100 %]

 
2) bzip2-devel python-devel

 
[Root @ mdb01 Packages] # rpm -ivh bzip2-devel-1.0.5-7.el6_0.x86_64.rpm

warning: bzip2-devel-1.0.5-7.el6_0.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: bzip2-devel ########################################### [100 %]

[Root @ mdb01 Packages] # rpm -ivh python-devel-2.6.6-29.el6_2.2.x86_64.rpm

warning: python-devel-2.6.6-29.el6_2.2.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: python-devel ########################################### [100 %]

[Root @ mdb01 Packages] #

 
Boost system related packages installed check

[Root @ mdb01 Packages] # rpm -q gcc gcc-c ++ bzip2 bzip2-devel bzip2-libs python-devel

gcc-4.4.6-4.el6.x86_64

gcc-c ++ - 4.4.6-4.el6.x86_64

bzip2-1.0.5-7.el6_0.x86_64

bzip2-devel-1.0.5-7.el6_0.x86_64

bzip2-libs-1.0.5-7.el6_0.x86_64

python-devel-2.6.6-29.el6_2.2.x86_64

[Root @ mdb01 Packages] #

Two .cmake-3.3.2

 # ./bootstrap

 # Make

 # Make install

Three .boost_1_59_0

1. precompiled configuration

[Root @ mdb01 boost_1_59_0] # ./bootstrap.sh

Building Boost.Build engine with toolset gcc ... tools / build / src / engine / bin.linuxx86_64 / b2

Detecting Python version ... 2.6

Detecting Python root ... / usr

Unicode / ICU support for Boost.Regex? ... Not found.

Generating Boost.Build configuration in project-config.jam ...

. Bootstrapping is done To build, run:

    ./b2

To adjust configuration, edit 'project-config.jam'.

Further information:

  - Command line help:

    ./b2 --help

  - Getting started guide:

http://www.boost.org/more/getting_started/unix-variants.html

  - Boost.Build documentation:

http://www.boost.org/build/doc/html/index.html

[Root @ mdb01 boost_1_59_0] #

2. Compile

[Root @ rhel6 boost_1_59_0] #. / B2

...........

...........

... On 1100th target ...

gcc.compile.c ++ bin.v2 / libs / wave / build / gcc-4.4.6 / release / link-static / threading-multi / wave_config_constant.o

common.mkdir bin.v2 / libs / wave / build / gcc-4.4.6 / release / link-static / threading-multi / cpplexer

common.mkdir bin.v2 / libs / wave / build / gcc-4.4.6 / release / link-static / threading-multi / cpplexer / re2clex

gcc.compile.c ++ bin.v2 / libs / wave / build / gcc-4.4.6 / release / link-static / threading-multi / cpplexer / re2clex / aq.o

gcc.compile.c ++ bin.v2 / libs / wave / build / gcc-4.4.6 / release / link-static / threading-multi / cpplexer / re2clex / cpp_re.o

gcc.archive bin.v2 / libs / wave / build / gcc-4.4.6 / release / link-static / threading-multi / libboost_wave.a

common.copy stage / lib / libboost_wave.a

... Updated 1107 targets ...

The Boost C ++ Libraries were successfully built! (Represented compile successfully)

The following directory should be added to compiler include paths:

    / Home / soft / boost_1_59_0

The following directory should be added to linker library paths:

    / Home / soft / boost_1_59_0 / stage / lib

3. Install

[Root @ mdb01 boost_1_59_0] #. / B2 install

...........

...........

common.copy /usr/local/lib/libboost_signals.so.1.59.0

ln-UNIX /usr/local/lib/libboost_signals.so

common.copy /usr/local/lib/libboost_timer.so.1.59.0

ln-UNIX /usr/local/lib/libboost_timer.so

common.copy /usr/local/lib/libboost_prg_exec_monitor.so.1.59.0

ln-UNIX /usr/local/lib/libboost_prg_exec_monitor.so

common.copy /usr/local/lib/libboost_unit_test_framework.so.1.59.0

ln-UNIX /usr/local/lib/libboost_unit_test_framework.so

common.copy /usr/local/lib/libboost_wave.so.1.59.0

ln-UNIX /usr/local/lib/libboost_wave.so

common.copy /usr/local/lib/libboost_exception.a

common.copy /usr/local/lib/libboost_system.a

common.copy /usr/local/lib/libboost_chrono.a

common.copy /usr/local/lib/libboost_timer.a

common.copy /usr/local/lib/libboost_test_exec_monitor.a

... Updated 11816 targets ...

[Root @ mdb01 boost_1_59_0] #

Four .mysql

1.MySQL source installation system requirements

Source Installation System Requirements

  Installation of MySQL from source requires several

  development tools. Some of these tools are needed no matter

  whether you use a standard source distribution or a

  development source tree. Other tool requirements depend on

  which installation method you use.

 To install MySQL from source, your system must have the

  following tools, regardless of installation method:

    * CMake, which is used as the build framework on all

      platforms. CMake can be downloaded from

      http://www.cmake.org.

    * A good make program. Although some platforms come with

      their own make implementations, it is highly recommended

      that you use GNU make 3.75 or newer. It may already be

      available on your system as gmake. GNU make is available

      from http://www.gnu.org/software/make/.

    * A working ANSI C ++ compiler. GCC 4.4.6 or later, Clang

      3.3 or later (FreeBSD and OS X), Visual Studio 2013 or

      later, and many current vendor-supplied compilers are

      known to work.

    * Perl is needed if you intend to run test scripts. Most

      Unix-like systems include Perl. On Windows, you can use a

      version such as ActiveState Perl.

2. Check the system package version

1) cmake

[Root @ mdb01 cmake-3.3.2] # cmake --version

cmake version 3.3.2


CMake suite maintained and supported by Kitware (kitware.com/cmake).

[Root @ mdb01 cmake-3.3.2] #

2) make

[Root @ mdb01 cmake-3.3.2] # make -v

GNU Make 3.81

Copyright (C) 2006 Free Software Foundation, Inc.

This is free software; see the source for copying conditions.

There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A

PARTICULAR PURPOSE.

This program built for x86_64-RedHat-linux-gnu

3) gcc

[Root @ mdb01 cmake-3.3.2] # gcc -v

Using built-in specs.

Target: x86_64-redhat-linux

Configured with: ../configure --prefix = / usr --mandir = / usr / share / man --infodir = / usr / share / info --with-bugurl = http: //bugzilla.redhat.com/bugzilla --enable-bootstrap --enable-shared --enable-threads = posix --enable-checking = release --with-system-zlib --enable -__ cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique -object --enable-languages = c, c ++, objc, obj-c ++, java, fortran, ada --enable-java-awt = gtk --disable-dssi --with-java-home = / usr / lib / jvm / java-1.5.0-gcj-1.5.0.0 / jre --enable-libgcj-multifile --enable-java-maintainer-mode --with-ecj-jar = / usr / share / java / eclipse-ecj. jar --disable-libjava-multilib --with-ppl --with-cloog --with-tune = generic --with-arch_32 = i686 --build = x86_64-redhat-linux

Thread model: posix

gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC)

[Root @ mdb01 cmake-3.3.2] #

4) perl

[Root @ mdb01 cmake-3.3.2] # perl -v


This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi

Copyright 1987-2009, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on

this system using "man perl" or "perldoc perl". If you have access to the

Internet, point your browser at http://www.perl.org/, the Perl Home Page.

[Root @ mdb01 cmake-3.3.2] #

5) Other systems package

ncurses-devel bison

[Root @ mdb01 Packages] # rpm -ivh ncurses-devel-5.7-3.20090208.el6.x86_64.rpm

warning: ncurses-devel-5.7-3.20090208.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: ncurses-devel ########################################### [100 %]

[Root @ mdb01 Packages] # rpm -ivh bison-2.4.1-5.el6.x86_64.rpm

warning: bison-2.4.1-5.el6.x86_64.rpm: Header V3 RSA / SHA256 Signature, key ID fd431d51: NOKEY

Preparing ... ########################################### [100% ]

  1: bison ########################################### [100%]

[Root @ mdb01 Packages] #

3. Pre-installation configuration

# Preconfiguration setup

[Root @ mdb01 soft] # groupadd mysql

[Root @ mdb01 soft] # useradd -r -g mysql mysql

# Beginning of source-build specific instructions

[Root @ mdb01 soft] # tar zxvf mysql-5.7.9.tar.gz

[Root @ mdb01 soft] # cd mysql-5.7.9

4. Configuration Installation items

[Root @ mdb01 mysql-5.7.9] # cmake \

> -DCMAKE_INSTALL_PREFIX = / Opt / mysql \

> -DMYSQL_DATADIR = / Opt / mysql / data \

> -DSYSCONFDIR = / Etc \

> -DWITH_MYISAM_STORAGE_ENGINE = 1 \

> -DWITH_INNOBASE_STORAGE_ENGINE = 1 \

> -DWITH_PARTITION_STORAGE_ENGINE = 1 \

> -DMYSQL_UNIX_ADDR = / Opt / mysql / mysql.sock \

> -DMYSQL_TCP_PORT = 3306 \

> -DENABLED_LOCAL_INFILE = 1 \

> -DEXTRA_CHARSETS = All \

> -DDEFAULT_CHARSET = Utf8 \

> -DDEFAULT_COLLATION = Utf8_general_ci

5. Compile MySQL

[Root @ mdb01 mysql-5.7.9] # make

6. Install MySQL

[Root @ mdb01 mysql-5.7.9] # make install

# End of source-build specific instructions

Fifth, post-installation configuration

# Postinstallation setup

1. Directory Permissions

shell> cd / opt / mysql

shell> chown -R mysql.

shell> chgrp -R mysql.

2. Initialize the database

shell> bin / mysql_install_db --user = mysql # Before MySQL 5.7.6

shell> bin / mysqld --initialize --user = mysql # MySQL 5.7.6 and up

Results of the:

[Root @ mdb01 mysql] # bin / mysqld --initialize --user = mysql

2015-10-29T21: 58: 57.465483Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated Please use --explicit_defaults_for_timestamp server option (see documentation for more details)..

2015-10-29T21: 58: 59.889999Z 0 [Warning] InnoDB: New log files created, LSN = 45790

2015-10-29T21: 59: 00.201432Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2015-10-29T21: 59: 00.398966Z 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:. 42ad8740-7e88-11e5-83de- 000c29270868.

2015-10-29T21: 59: 00.406427Z 0 [Warning] Gtid table is not ready to be used Table 'mysql.gtid_executed' can not be opened..

2015-10-29T21: 59: 00.424627Z 1 [Note] A temporary password is generated for root @ localhost:! Ek & sA9 (qYds

[Root @ mdb01 mysql] # ls

bin COPYING data docs include INSTALL-BINARY lib man mysql-test README share support-files

[Root @ mdb01 mysql] #

3. The relevant certificate

shell> bin / mysql_ssl_rsa_setup # MySQL 5.7.6 and up

Results of the

[Root @ mdb01 mysql] # bin / mysql_ssl_rsa_setup

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'

-----

[Root @ mdb01 mysql] #

4. Modify the directory permissions

shell> chown -R root.

shell> chown -R mysql data

Basedir mysql user

[Root @ mdb01 mysql-5.7.9] # cd / opt

[Root @ mdb01 opt] # chown mysql mysql

[Root @ mdb01 opt] # ll

total 4

drwxr-xr-x. 11 mysql mysql 4096 Oct 30 06:09 mysql

5. Start MySQL

shell> bin / mysqld_safe --user = mysql &

Six debut MySQL

1. Log in MySQL

[Root @ rhel6 mysql] # bin / mysql -u root -p

Enter password:! Temporary password generated during the installation (Ek & sA9 (qYds)

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

Your MySQL connection id is 3

Server version: 5.7.9-log

Copyright (c) 2000, 2015, Oracle and / or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and / or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\ h' for help Type '\ c' to clear the current input statement..

mysql>

2. Modify the login password root password

* As of MySQL 5.7.6, use ALTER USER:

mysql> ALTER USER 'root' @ 'localhost' IDENTIFIED BY '123456';

Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

3. Configure startup items

# Next command is optional

shell> cp support-files / mysql.server /etc/init.d/mysqld

PATH environment variable

vi / etc / profile

.....

.....

unset i

unset pathmunge

export PATH = / opt / mysql / bin: $ PATH
     
         
       
         
  More:      
 
- Docker build private warehouse (Server)
- Amazon EC2 server using Rsync + Inotify real-time synchronization (Server)
- C ++ copy constructor (Programming)
- Hadoop new and old version of the difference in the size of the InputSplit (Server)
- Web database security tips (Linux)
- Linux terminal program running in the background (Linux)
- Linux installation is larger than 2TB (UEFI interface) hard disk solution (Linux)
- Kubernetes cluster deployment (Server)
- Detailed driver compiled into the Linux kernel (Programming)
- Firewall chapter of Linux server security configuration (Linux)
- Installation and use of Linux Sniffer tool Tcpdump (Linux)
- Help you to see Linux system architecture type 5 Common Commands (Linux)
- Linux support exFAT and NTFS (Linux)
- Linux system boot process detail (Linux)
- MySQL query plan key_len know all (Database)
- Oracle 11g RMAN cross-platform transfer table space (Database)
- How to configure Ceph stored on CentOS 7.0 (Server)
- Build your own CA services: OpenSSL command line CA Quick Guide (Server)
- The new features of MySQL 5.7 Generated Column (index function) (Database)
- CentOS install pip (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.