Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL5.7.10 installation documentation     - Java rewrite the hashcode method (Programming)

- Linux upgrade Glibc (Linux)

- SSH configuration under Linux (Linux)

- Linux some lessons learned about network security (Linux)

- PF_RING 6.0.2 compiled and installed on Redhat 6.3 x86_64 (Linux)

- Oracle 12C RAC on temporary table space Enlighten (Database)

- Permissions and attributes of files and directories under Linux (Linux)

- Linux instructions and examples GPG encryption and decryption (Linux)

- MySQLbinlog combat on using data recovery (Database)

- JavaScript object - Flexible and dangerous (Programming)

- MySQL appears data too long for column 'name' at row 1 to solve (Database)

- Oracle database with test data insertion speed (Database)

- Python in os.path Magical (Programming)

- MySQL replication master and slave structure built (Database)

- The virtual memory (Linux)

- Quick paging ROW_NUMBER conducted (Database)

- Linux C source code (Ascii HexToBinary: Converts hexadecimal string format ASCII codes) (Programming)

- Unetbootin make use U disk loading Linux system (Linux)

- Use NTFS-3G to mount NTFS partitions under Linux U disk and removable hard disk (Linux)

- ASP.NET 5 tutorial series (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:      
 
- Getting Started with Linux system to learn: how to use tcpdump to capture TCP SYN, ACK and FIN packets (Linux)
- Upgrading from Fedora 20 to 21 (Linux)
- Linux system network security tools sudo Introduction (Linux)
- Use ISO document production OpenStack used CoreOS mirror (Linux)
- linux smartd [FAILED] appears at startup (Linux)
- JSON Introduction and Usage Summary (Programming)
- Apache Linux firewall reverse proxy configuration (Linux)
- Linux `dirname $ 0` (Linux)
- How to use the beta / unstable version of the software in Debian library (Linux)
- Installation Enpass secure password manager on Ubuntu (Linux)
- Job achieve automation in Ubuntu 14.04 - Using Cron (Linux)
- Use Oracle 11g show spparameter command (Database)
- How to Install Xombrero 1.6.4 (minimalist Web browser) on Ubuntu and Archlinux (Linux)
- Enterprise Hadoop cluster architecture - DNS installation (Server)
- Kickstart automated installation and deployment RHEL 7.0 (Linux)
- Elaborate .NET Multithreading: Concepts (Programming)
- Introduction to Linux system process monitoring tools (Linux)
- Deploy the project to the server from GitHub (Server)
- MySQL use the integer type (Database)
- 32-bit and 64-bit integer in PHP and MySQL range (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.