System environment:
[Email protected] ~]# cat/etc/redhat-release
CentOS Release 6.7 (Final)
[Email protected] tools]# uname-a
Linux localhost 2.6.32-573.22.1.el6.x86_64 #1 SMP Wed Mar 03:35:39 UTC x86_64 x86_64 x86_64 gnu/linux
[Email protected] tools]#
Software Preparation:
[Email protected] tools]# pwd
/opt/tools
[email protected] tools]# LL
Total 674208
-rw-r--r--1 root root 639864682 Jul 17:47 mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz
-rw-r--r--1 root root 50516207 may 12:01 mysql-5.7.13.tar.gz
[Email protected] tools]#
Unzip the installation:
[Email protected] tools]# Tar XF mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz
[email protected] tools]# LL
Total 674212
Drwxr-xr-x 9 7161 wheel 4096 15:04 mysql-5.7.13-linux-glibc2.5-x86_64
-rw-r--r--1 root root 639864682 Jul 17:47 mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz
-rw-r--r--1 root root 50516207 may 12:01 mysql-5.7.13.tar.gz
[Email protected] tools]#
[Email protected] tools]# MV Mysql-5.7.13-linux-glibc2.5-x86_64/usr/local/mysql
[[Email Protected]ocalhost tools]#
Initialize operation (generate initial password):
[Email protected] mysql]#/bin/mysqld--initialize--user=mysql--basedir=/usr/local/mysql--datadir=/data/mysql/ Data
2016-07-22t09:58:15.001776z 0 [Warning] innodb:new log files created, lsn=45790
2016-07-22t09:58:15.062066z 0 [Warning] innodb:creating FOREIGN KEY constraint system tables.
2016-07-22t09:58:15.073009z 0 [Warning] No existing UUID have been found, so we assume that's the first time that thi s server has been started. Generating a new uuid:cebfb8a6-4ff2-11e6-8c8d-005056a01a07.
2016-07-22t09:58:15.074370z 0 [Warning] Gtid table is not a ready-to-be used. Table ' mysql.gtid_executed ' cannot be opened.
2016-07-22t09:58:15.075736z 1 [Note] A temporary password is generated for [email protected]: k_1ljzvh3<-,
[Email protected] mysql]#
ps:mysql5.7 new features: As can be seen above, mysql_install_db is no longer recommended to use, it is recommended to change to mysqld--initialize to complete the initialization of the instance.
Join MySQL for system services:
[email protected] mysql]# CP support-files/mysql.server/etc/init.d/mysqld
[Email protected] mysql]# chkconfig mysqld on
[Email protected] mysql]# chkconfig--list|grep mysqld
Mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[[email protected] MySQL] #chmod 755/etc/init.d/mysqld
MySQL service starts, restarts, stops
[Email protected] mysql]# serivce mysqld start
[[email protected] mysql]# serivce mysqld stop
[Email protected] mysql]# serivce mysqld restart
[Email protected] mysql]#
Set Environment variables:
[Email protected] mysql]# Vim/etc/profile
Export Path=/usr/local/mysql/bin: $PATH
[Email protected] mysql]#
Check to see if MySQL is open
[Email protected] mysql]# Cd/usr/local/mysql
[Email protected] mysql]# CD support-files/
[[email protected] support-files]#./mysql.server start
Starting MySQL. success!
If you use it, the following error occurs when you start the service:
#./support-files/mysql.server Start
./support-files/mysql.server:line 276:CD:/usr/local/mysql:no such file or directory
Starting MySQL error! Couldn ' t find MySQL server (/usr/local/mysql/bin/mysqld_safe)
At this time we need to modify the Basedir and DataDir directory Paths of the/support-files/mysql.server files for our correct MySQL basedir and datadir paths, as follows:
# Vim Support-files/mysql.server
--------------------------
...
Basedir=/usr/local/mysql
Datadir=/data/mysql/data
...
--------------------------
# ./support-files/mysql.server start
Starting MySQL. success!
Creating a configuration file
MY.CNF backup that will be generated by default
# Mv/etc/my.cnf/etc/my.cnf.bak
[email protected] support-files]# CP my-default.cnf/etc/my.cnf
Initialize the password of the MySQL user root
Stop the MySQL service first
# Service Mysqld Stop
Go to the MySQL installation directory and execute:
# Cd/usr/local/mysql
# ./bin/mysqld_safe--skip-grant-tables--skip-networking&
[1] 6225
[Email protected] mysql]# 151110 02:46:08 mysqld_safe Logging to '/data/mysql/data/localhost.localdomain.err '.
151110 02:46:08 Mysqld_safe starting mysqld daemon with databases From/data/mysql/data
Also open a terminal (p.s. If the SSH connection is logged in, create an SSH connection), do the following:
# mysql-u Root MySQL
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 2
Server version:5.7.13 MySQL Community Server (GPL)
Copyright (c), Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.
Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.
mysql> use mysql;
Database changed
mysql> UPDATE user SET Password=password (' 123456 ') WHERE user= ' root ';
ERROR 1054 (42S22): Unknown column ' Password ' in ' Field list '
mysql> Update user Set authentication_string = PASSWORD (' 123456 ') where user = ' root ';
Query OK, 1 row affected, 1 Warning (0.02 sec)
Rows matched:1 changed:1 warnings:1
Mysql> flush Privileges;
Query OK, 0 rows Affected (0.00 sec)
mysql> \s
MySQL Ver 14.14 distrib 5.7.13, for linux-glibc2.5 (x86_64) using Editline Wrapper
Connection id:62
Current database:
Current User: [email protected]
Ssl:not in use
Current Pager:stdout
Using outfile: '
Using delimiter:;
Server Version:5.7.13-log MySQL Community Server (GPL)
Protocol version:10
Connection:localhost via UNIX socket
Server Characterset:utf8
Db Characterset:utf8
Client Characterset:utf8
Conn. Characterset:utf8
UNIX Sockets:/data/aedata/mysql/data/mysql.sock
uptime:46 min sec
Threads:6 questions:6846 Slow queries:0 opens:257 Flush tables:1 Open tables:201 queries per second avg:2.432
--------------
Mysql>
To this end, set the MySQL user root password and make sure that the MySQL encoding set is UTF8, note that the new version of the Mysql.user table password field is authentication_string
MySQL Remote authorization
The format is as follows:
mysql> grant all [privileges] on db_name.table_name to ' username ' @ ' host ' identified by ' password ';
Examples are as follows:
Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ';
Query OK, 0 rows affected, 1 warning (0.04 sec)
mysql> FLUSH privileges;
Query OK, 0 rows Affected (0.00 sec)
Mysql>
or with
Mysql> Grant All on * * to ' root ' @ '% ' identified by ' 123456 ';
To this, completed the installation and configuration of MySQL!!!
Reference case: http://blog.csdn.net/cryhelyxx/article/details/49757217
This article from "Flat Light is true" blog, please be sure to keep this source http://ucode.blog.51cto.com/10837891/1829575
centos6.7 deployment of MySQL-5.7.13 in 64-bit environments