Linux environment Mysql 5.7.13 installation
Http://www.cnblogs.com/zhao1949/p/5947938.html
The installation tutorial of Mysql 5.7.13 in linux environment is shared for your reference. The details are as follows
1 system convention
Download directory of installation files: / data/software
Mysql directory installation location: / usr/local/mysql
Database location: / data/mysql
Log location: / data/log/mysql
2 download mysql
On the official website: http://dev.mysql.com/downloads/mysql/, select the following version of mysql to download:
Perform the following naming:
# mkdir / data/software
# cd / data/software
# wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz
3 decompress the package to the target location
# mkdir / usr/local/mysql
# cd / dat/software
# pwd
After implementation, it is as follows:
# ls
# cd / usr/local
# pwd
# tar-xzvf / data/software/mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz
# ls
-- modify the file name
# mv mysql-5.7.13-linux-glibc2.5-x86_64 mysql
# ls
4 create a data warehouse directory
-/ data/mysql data warehouse directory
# mkdir / data/mysql
# ls / data/
5 create new mysql users, groups and directories
#-create a new msyql group
# useradd-r-s / sbin/nologin-g mysql mysql-d / usr/local/mysql-New msyql users are prohibited from logging in to shell
6 change the owner of the directory
# cd / usr/local/mysql
# pwd
# chown-R mysql.
# chgrp-R mysql.
# chown-R mysql / data/mysql
7 configuration parameters
# bin/mysqld-initialize-user=mysql-basedir=/usr/local/mysql-datadir=/data/mysql
You need to pay attention to the temporary password generated by the record here, as above: YLi > 7ecpetYP
# bin/mysql_ssl_rsa_setup-datadir=/data/mysql
8 modify the system configuration file
# cp my-default.cnf / etc/my.cnf
# cp mysql.server / etc/init.d/mysql
# vim / etc/init.d/mysql
Modify the following:
[client]
Port=3306
# socket=/usr/local/mysql/mysql.sock
Socket=/data/mysql/mysql.sock
[mysqld]
Basedir=/usr/local/mysql
Datadir=/data/mysql
# socket=/usr/local/mysql/mysql.sock
Socket=/data/mysql/mysql.sock
Pid-file=/data/mysql/mysqld.pid
# vim / etc/my.cnf
Modify the following:
9 start mysql
# bin/mysqld_safe-- user=mysql &
Bin/mysql-user=root-p
-enter the temporary password generated in step 6
Mysql > set password=password ('A123456')
Mysql > grant all privileges on *. * to 'root'@'%' identified by' A123456'
Mysql > flush privileges
Mysql > use mysql
Mysql > select host,user from user
10 add system path
# vim / etc/profile
Add:
Export PATH=/usr/local/mysql/bin:$PATH
As follows:
# source / etc/profile
11 configure mysql to start automatically
# chmod 755 / etc/init.d/mysql
# chkconfig-add mysql
# chkconfig-- level 345 mysql on
The above is the linux environment Mysql 5.7.13 installation tutorial, I hope to be helpful to your study.
My.cn attached
/ etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# * * DO NOT EDIT THIS FILE. It's a template which will be copied to the
# * * default location during install, and will be replaced if you
# * * upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
Innodb_buffer_pool_size = 10G
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
Log_bin
Character-set-server=utf8
Collation-server=utf8_bin
Init-connect='SET NAMES utf8'
# These are commonly set, remove the # and set as required.
Basedir = / usr/local/mysql
Datadir = / export/mysql/var
Port = 3306
Server_id = 22206
Socket = / export/mysql/mysql.sock
Binlog_format = statement
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
Join_buffer_size = 128m
Sort_buffer_size = 2m
Read_rnd_buffer_size = 2m
Log_bin_trust_function_creators = on
Sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
Lower_case_table_names=1
