Linux 5 下安装MySQL 5.6(RPM方式)

Linux 5 下安装MySQL 5.6(RPM方式)

MySQL在很多领域被广泛使用，尤其是很多互联网企业，诸如腾讯，阿里等等。本文主要介绍在Linux 5下通过rpm方式来安装Mysql，这是比较简单的一种安装方式，具体详见下文。

《MySQL权威指南(原书第2版)》清晰中文扫描版 PDF

1、准备对应的安装文件
下载页面：http://dev.mysql.com/downloads/mysql/
找到对应的版本及所需的文件进行下载，如果下载的为tar文件，请使用tar解压
本人在Oracle Edelivery 下载，所以为V44331-01.zip
#安装环境
[root@linux1 Mysql_src]# cat /etc/issue
Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Kernel \r on an \m
#源文件路径
[root@linux1 Mysql_src]# pwd
/Mysql_src
[root@linux1 Mysql_src]# unzip V44331-01.zip
Archive:  V44331-01.zip
 extracting: MySQL-embedded-advanced-5.6.17-1.rhel5.i386.rpm 
 extracting: MySQL-test-advanced-5.6.17-1.rhel5.i386.rpm 
 extracting: MySQL-shared-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL的共享库
 extracting: MySQL-devel-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL的库和头文件
 extracting: MySQL-client-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL客户端程序
 extracting: MySQL-server-advanced-5.6.17-1.rhel5.i386.rpm          # MySQL服务端程序
 extracting: MySQL-shared-compat-advanced-5.6.17-1.rhel5.i386.rpm  # RHEL兼容包
 extracting: README.txt             

2、MySQL默认安装路径
 Directory            Contents of Directory
/usr/bin              Client programs and scripts
/usr/sbin              The mysqld server
/var/lib/mysql        Log files, databases
/usr/share/info        Manual in Info format
/usr/share/man        Unix manual pages
/usr/include/mysql    Include (header) files
/usr/lib/mysql        Libraries
/usr/share/mysql      Miscellaneous support files, including error messages,
                        character set files, sample configuration files, SQL for database installation
/usr/share/sql-bench  Benchmarks

3、安装MySQL
[root@linux1 Mysql_src]# rpm -ivh MySQL-server-advanced-5.6.17-1.rhel5.i386.rpm
Preparing...                ########################################### [100%]
  1:MySQL-server-advanced  ########################################### [100%]
2014-04-15 17:26:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-04-15 17:26:59 6524 [Note] InnoDB: Using mutexes to ref count buffer pool pages
                  ...........................
2014-04-15 17:27:06 6558 [Note] InnoDB: FTS optimize thread exiting.
2014-04-15 17:27:06 6558 [Note] InnoDB: Starting shutdown...
2014-04-15 17:27:08 6558 [Note] InnoDB: Shutdown completed; log sequence number 1625987

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.

You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.

Also, the account for the anonymous user has been removed.

In addition, you can run:

  /usr/bin/mysql_secure_installation

#  Author : Leshami
#  Blog  :