mysql 5.7.9安装_MySQL 5.7.9 安装

下载mysql

shell># wget http://cdn.mysql.com/Downloads/MySQL-5.7/mysql-5.7.9.tar.gz

shell># ll

-rw-r--r--  1 root root 312845162 Nov 11 16:25 mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz

-rw-r--r--  1 root root 611640358 Nov 11 16:27 mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz

解压到/usr/local/

shell># tar -zxf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz -C /usr/local/

检查依赖包libaio，mysql需要使用异步IO

shell># rpm -qa|grep libaio

libaio-0.3.107-10.el6.x86_64

增加mysql组

shell># groupadd mysql

shell># useradd -r -g mysql mysql

设置权限

shell># cd /usr/local

shell># ln -s mysql-5.7.9-linux-glibc2.5-x86_64 mysql

shell># mkdir mysql-files

shell># chmod 770 mysql-files

shell># chown -R mysql .

shell># chgrp -R mysql .

修改相关数据目录

shell># vi /etc/my.cnf

[mysqld]

datadir=/home/mysql

socket=/home/mysql/mysql.sock

user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

[mysqld_safe]

log-error=/home/mysql/error.log

pid-file=/home/mysql/mysqld.pid

shell> bin/mysql_install_db --user=mysql    # Before MySQL 5.7.6

shell> bin/mysqld --initialize --user=mysql # MySQL 5.7.6 and up

shell> bin/mysql_ssl_rsa_setup              # MySQL 5.7.6 and up

初始化数据库

shell># bin/mysqld --initialize --user=mysql

2015-11-13T03:35:03.910909Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2015-11-13T03:35:04.051875Z 0 [Warning] InnoDB: New log files created, LSN=45790

2015-11-13T03:35:04.081030Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2015-11-13T03:35:04.134482Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 86fbe8f6-89b7-11e5-aacd-c81f66f10582.

2015-11-13T03:35:04.134868Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2015-11-13T03:35:04.135431Z 1 [Note] A temporary password is generated for root@localhost: nwpD(-Nap1r2

shell># bin/mysql_ssl_rsa_setup

Generating a 2048 bit RSA private key

.....................+++

.....................+++

writing new private key to 'ca-key.pem'

-----

Generating a 2048 bit RSA private key

.................................................................................+++

...........................+++

writing new private key to 'server-key.pem'

-----

Generating a 2048 bit RSA private key

.....................+++

...............................+++

writing new private key to 'client-key.pem'

-----

shell># chown -R root .

shell># ll

total 160

drwxr-xr-x  2 root mysql   4096 Oct 12 15:30 bin

-rw-r--r--  1 root mysql  17987 Oct 12 14:21 COPYING

drwxr-xr-x  2 root mysql   4096 Oct 12 15:30 docs

drwxr-xr-x  3 root mysql   4096 Oct 12 15:30 include

-rw-r--r--  1 root mysql 108028 Oct 12 14:21 INSTALL-BINARY

drwxr-xr-x  5 root mysql   4096 Oct 12 15:30 lib

drwxr-xr-x  4 root mysql   4096 Oct 12 15:29 man

-rw-r--r--  1 root mysql   2478 Oct 12 14:21 README

drwxr-xr-x 28 root mysql   4096 Oct 12 15:30 share

drwxr-xr-x  2 root mysql   4096 Nov 13 11:32 support-files

shell># chown -R mysql /home/mysql

后台启动MySQL

shell># bin/mysqld_safe --user=mysql &

[1] 32559

shell># 151113 11:36:12 mysqld_safe Logging to '/home/mysql/mysqld.log'.

151113 11:36:12 mysqld_safe Starting mysqld daemon with databases from /home/mysql

shell># ps -ef | grep mysql

root     32559 32076  0 11:36 pts/1    00:00:00 /bin/sh bin/mysqld_safe --user=mysql

mysql    32725 32559  0 11:36 pts/1    00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/home/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/home/mysql/mysqld.log --pid-file=/home/mysql/mysqld.pid --socket=/home/mysql/mysql.sock

root     32887 32076  0 11:39 pts/1    00:00:00 grep mysql

shell># mysql

-bash: mysql: command not found

增加环境变量

shell># vi .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/usr/local/mysql/bin

export PATH

~

shell># source .bash_profile

mysql -uroot -p -S /home/mysql/mysql.sock

Enter password:

mysql> show databases;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED by 'oraclemysql';

Query OK, 0 rows affected (0.00 sec)

启动脚本，设置开机自启动

shell># cd /usr/local/mysql

shell># cp support-files/mysql.server /etc/init.d/mysql

shell># /etc/init.d/mysql status

MySQL running (33907)[  OK  ]

shell># chkconfig --list|grep mysql

shell># chkconfig --add mysql

shell># chkconfig --list|grep mysql

mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off

测试安装是否正常

shell># service mysql stop

Shutting down MySQL..[  OK  ]

shell># service mysql start

Starting MySQL.[  OK  ]

shell># mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

shell># mysql -S /home/mysql/mysql.sock -uroot -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.9 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| sys                |

+--------------------+

4 rows in set (0.00 sec)