Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL5.7.10 installation documentation     - How to enhance the security of Linux systems (Linux)

- Linux environment variable configuration and save places (Linux)

- How to update the ISPConfig 3 SSL Certificates (Server)

- installation of Vim plugin YouCompleteMe under Ubuntu 15.04 (Linux)

- Define and modify strings principle in Python (Programming)

- Realization of Linux operating system illegal IP censorship (Linux)

- The user of fedora is not in the sudoers file method to solve (Linux)

- The file name is garbled or deleted files with special characters under Linux (Linux)

- After VMware CentOS full VM clone the network card is unavailable Solutions (Linux)

- Linux using DenyHosts prevents ssh cracks (Linux)

- Ubuntu install Eclipse for C / C ++ and related configuration (Linux)

- sed command (Linux)

- Linux print file and send mail (Linux)

- Python Flask environment to build (Linux)

- C ++ virtual functions Classic Insights (Programming)

- Basic data types JavaScript type system and the type of packaging (Programming)

- 12 Linux Process Management Commands (Linux)

- How to Check notebook CPU temperature in Ubuntu (Linux)

- When a software RAID data recovery and reconstruction of how failure (Linux)

- Vi syntax highlighting settings (Linux)

  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


(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


character_set_server = utf8

init_connect = 'SET NAMES utf8'


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.
- Use chattr and lsattr command to manage linux files and directory attributes (Linux)
- About Linux backdoor (Linux)
- The REVERSE function of DB2 (Database)
- SteamOS installation under Ubuntu 14.04 (Linux)
- Oracle metadata Reconstruction experiments (Database)
- Let Ubuntu 14.04 Save screen luminance value (Linux)
- Getting Started with Linux system to learn: how to install the kernel headers on Linux (Linux)
- Teach you the Ubuntu Server enabled SSH multifactor authentication (Server)
- Linux and SELinux Exploration Program Manager (Linux)
- Automated Password Generator: Linux under a special password generator (Linux)
- CentOS7 set boot directly into the command line interface (Linux)
- CentOS 6.5 set under Oracle 12c at startup (Database)
- Install Oracle database error process of [INS-35172] (Database)
- Kickstart automated installation and deployment RHEL 7.0 (Linux)
- Python Django direct implementation of sql statement (Programming)
- CentOS 5.5 kernel upgrade installation iftop (Linux)
- Tip: Use Cryptsetup U disk encryption (Linux)
- Slow update statement Performance Analysis (Database)
- The Linux C truncate function clears the file notes (Programming)
- Cacti installation deployment under CentOS 6.6 (Server)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.