Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL5.7.10 installation documentation     - Nginx log cutting and MySQL script regular backup script (Server)

- Java Learning: elegant string (Programming)

- Android Service service applications and the phone SMS Listener Listener (Programming)

- Use PuTTY key authentication mechanism for remote login Linux (Linux)

- Linux / Unix: chroot command examples to explain (Linux)

- Ubuntu 14.10 / 14.04 / 12.04 installation GNOME Pie 0.5.6 (Linux)

- Struts2 dynamic call DMI and error Solution (Programming)

- Linux how to handle file names that contain spaces and special characters (Linux)

- HashMap in Android and Java different implementations (Programming)

- Configuring DNS process under CentOS 6.5 (Server)

- Linux system network security tools sudo Introduction (Linux)

- Linux batch copy data script (Linux)

- CentOS 6.7 compile and install LAMP (Server)

- installation and configuration of the PHP environment (Apache2) under Linux (Server)

- HomeKit User Interface Guidelines (Linux)

- Linux operation and maintenance engineers face questions Intermediate (Linux)

- MySQL5.7 implement virtual column expression index (Database)

- Revive Adserver ad server installation on Ubuntu 15.04 / CentOS7 (Server)

- Ubuntu Eclipse configuration Gtk + 2.0 libraries (Linux)

- Nginx + ownCloud + PHP + MySQL to build personal private cloud under CentOS7 (Server)

 
         
  MySQL5.7.10 installation documentation
     
  Add Date : 2018-11-21      
         
         
         
  1, The installation dependencies

yum -y install gcc-c ++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison

2, the installation boost libraries:

First, first check whether installed boost

rpm -qa boost *

Uninstall old boost- * libraries like:

yum -y remove boost- *

Download Boost library, after decompression copied to / usr / local / boost directory, and then re-add options cmake -DWITH_BOOST later in options = / usr / local / boost

(Download: http: //sourceforge.net/projects/boost/files/boost/)

NOTE: boost for the 1.59.0 version mysql5.7.10 need not be other editions

Download: http: //liquidtelecom.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

3, download the source code mysql

Download the official website address: http: //cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.10.tar.gz

Download, unzip

4, the installation process

(1) Create a user group

# Groupadd mysql

# Mkdir / home / mysql # custom location

# Mkdir / home / mysql / data # custom location

# Useradd -g mysql -d / home / mysql mysql

(2) compile mysql

cmake -DCMAKE_INSTALL_PREFIX = / home / mysql -DMYSQL_DATADIR = / home / mysql / data -DDEFAULT_CHARSET = utf8 -DDEFAULT_COLLATION = utf8_general_ci -DMYSQL_TCP_PORT = 3306 -DMYSQL_USER = mysql -DWITH_MYISAM_STORAGE_ENGINE = 1 -DWITH_INNOBASE_STORAGE_ENGINE = 1 -DWITH_ARCHIVE_STORAGE_ENGINE = 1 -DWITH_BLACKHOLE_STORAGE_ENGINE = 1 - DWITH_MEMORY_STORAGE_ENGINE = 1 -DDOWNLOAD_BOOST = 1 -DWITH_BOOST = / usr / local / boost

(3) Install

The second step is not being given the case

make && make install

(4) initialize the database

Installed into the bin directory under the makeup, do

./mysqld --initialize --user = mysql --basedir = / home / mysql --datadir = / home / mysql / data

NOTE: The default password is generated after initialization, recorded
(5) adjust the configuration file parameters and environment variables

The default backup generate my.cnf

# Mv /etc/my.cnf /etc/my.cnf.bak

Enter the mysql installation directory support files directory

# Cd / mysql / support-files

Copy the configuration file for the new template configuration file mysql,

# Cp my-default.cnf /etc/my.cnf

Can be modified as needed new profile option does not modify the configuration options, mysql default configuration parameters press run.

As I modify the configuration file /etc/my.cnf, it is used to set the encoding utf8 prevent distortion

[Mysqld]

character_set_server = utf8

init_connect = 'SET NAMES utf8'

[Client]

default-character-set = utf8

Copy the startup script to the next init.d

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

Increased execute permissions

chmod 755 /etc/init.d/mysqld

Create mysql command file

ln -s / mysql / bin / mysql / usr / bin /

NOTE: There is no file in this command mysql, mysql to access the database can not be used in any position

(6) start mysql

service mysqld start

(7) access the database

mysql -uroot -p

Password just generated password

(8) to modify the default password

alter user 'root' @ 'localhost' identified by '123456';

NOTE: Do not change the default password, you can not normally use sql, you must modify
This referral, mysql5.7.10 installation is complete.

Being given the record:

cmake compile time, you may encounter boost library error, cause analysis: It may be downloaded boost version and mysql requirements inconsistent versions, boost version must be specified version mysql, lower or higher than the specified version are not available.
     
         
         
         
  More:      
 
- Embedded Linux to solve the problem in the time zone (Linux)
- To setup NOTRACK and TRACK of conntrack in iptables (Linux)
- CentOS iptables firewall configuration (Linux)
- About Hibernate cache, you want the latest data have trouble even session.clear (Database)
- C language - Traverse pci device (Programming)
- Java String and StringBuffer and StringBuilder Comments (Programming)
- Java multi-threaded communications pipeline flow (Programming)
- Python script running in the background (Programming)
- Linux_Logo - output color ANSI Linux distributions logo command-line tool (Linux)
- VMware virtual machine to use bridged mode fast Internet access (Linux)
- Github with .gitignore ignore specified file (Linux)
- Android custom title bar (Programming)
- Ubuntu resolve sudo: source: command not found error (Linux)
- How to install Laravel PHP framework on CentOS 7 / Ubuntu 15.04 (Server)
- Ansible installation configuration and simple to use (Server)
- VMware virtual machines to install virt-manager unable to connect to libvirt's approach (Linux)
- Puppet subcommands Introduction (Server)
- ORA-12547: TNS: lost contact error Solution (Database)
- How to install Kernel 4.0.2 on CentOS 7 (Linux)
- Use Hexo quickly build and deploy a blog to Github (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.