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)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26390465/viewspace-1836692/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26390465/viewspace-1836692/