CentOS安装MySQL数据库的三种方法

1、文档供参考，可复制、编制，期待您的好评与关注！ 最近在CentOS 5.10上安装最新版的mysql5.6.21时遇到了麻烦。于是将mysql文档中的关于如何在Linux上安装mysql的部分仔细的读了一遍。总结起来在CentOS或者Red Hat上安装mysql可以有三种方式：1)使用rpm -ivh .或者 yum install . (一般推荐使用rpm来安装)2)使用编译好的通用二进制版本的mysql来安装(Generic Binaries mysql) (在方法一失败时，可以使用方法2来安装)3)使用源码来编译安装。1. 在CentOS 5.10上安装最新版的mysql5.6.21时遇到的麻烦2. Installing MySQL on Unix/Linux Using Generic Binaries（使用通用二进制版本的mysql来安装） 当使用rpm或者yum方法安装失败时，可以使用该方法进行安装。因为通用二进制版本对glibc等lib库的版本要求不是很高。所以使用这种方法，可以很好的解决：在低版本的CentOS上安装高版本的mysql。其安装方法如下。2.1 下载 打

2、开网页：http:/ 在Select Platform: 中选择 Linux - Generic 然后下载最下面的：mysql-5.6.21-linux-glibc2.5-i686.tar.gz （有64位的和32位的，选择自己需要的）2.2 安装 具体安装步骤，mysql文档中有详细说明：To install and user a MySQL binary distribution, the basic command sequence looks like this:shell groupadd mysqlshell useradd -r -g mysql mysqlshell cd /usr/localshell tar zxvf /path/to/mysql-VERSION-OS.tar.gzshell ln -s full-path-to-mysql-VERSION-OSmysqlshell cd mysqlshell chown -R mysql .shell chgrp -R mysql .shell scripts/mysql_install_db -user=mysq

3、lshell chown -R root .shell chown -R mysql datashell bin/mysqld_safe -user=mysql &# Next command is optionalshell cp support-files/mysql.server /etc/init.d/mysql.server我自己的安装过程如下：rootlocalhost mysql# groupadd mysqlrootlocalhost mysql# useradd -r -g mysql mysqlrootlocalhost mysql# cd /usr/localrootlocalhost mysql# tar zxvf /root/mysql-5.6.21-linux-glibc2.5-i686.tar.gz rootlocalhost local# lltotal 76drwxr-xr-x 2 root root 4096 Nov 7 05:43 bindrwxr-xr-x 2 root root 4096 May 11 2011 etcdrwxr-xr-x 2

4、root root 4096 May 11 2011 gamesdrwxr-xr-x 3 root root 4096 Nov 7 05:43 includedrwxr-xr-x 4 root root 4096 Nov 7 05:43 libdrwxr-xr-x 2 root root 4096 May 11 2011 libexecdrwxr-xr-x 13 root root 4096 Nov 7 20:42 mysql-5.6.21-linux-glibc2.5-i686drwxr-xr-x 2 root root 4096 May 11 2011 sbindrwxr-xr-x 4 root root 4096 Nov 7 01:15 sharedrwxr-xr-x 2 root root 4096 May 11 2011 srcrootlocalhost local# pwd/usr/localrootlocalhost local# ln -s /usr/local/mysql-5.6.21-linux-glibc2.5-i686 mysqlrootlocalhost lo

5、cal# cd mysqlrootlocalhost mysql# chown -R mysql .rootlocalhost mysql# chgrp -R mysql .rootlocalhost mysql# scripts/mysql_install_db -user=mysqlInstalling MySQL system tables.2014-11-07 20:45:37 0 Warning TIMESTAMP with implicit DEFAULT value is deprecated. Please use -explic it_defaults_for_timestamp server option (see documentation for more details).2014-11-07 20:45:37 4083 Note InnoDB: Using mutexes to ref count buffer pool pages2014-11-07 20:45:37 4083 Note InnoDB: The InnoDB memory heap is

6、disabled2014-11-07 20:45:37 4083 Note InnoDB: Mutexes and rw_locks use InnoDBs own implementation2014-11-07 20:45:37 4083 Note InnoDB: Memory barrier is not used2014-11-07 20:45:37 4083 Note InnoDB: Compressed tables use zlib 1.2.32014-11-07 20:45:37 4083 Note InnoDB: Using Linux native AIO2014-11-07 20:45:37 4083 Note InnoDB: Not using CPU crc32 instructions2014-11-07 20:45:37 4083 Note InnoDB: Initializing buffer pool, size = 128.0M2014-11-07 20:45:37 4083 Note InnoDB: Completed initialization

7、 of buffer pool2014-11-07 20:45:37 4083 Note InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!2014-11-07 20:45:37 4083 Note InnoDB: Setting file ./ibdata1 size to 12 MB2014-11-07 20:45:37 4083 Note InnoDB: Database physically writes the file full: wait.2014-11-07 20:45:37 4083 Note InnoDB: Setting log file ./ib_logfile101 size to 48 MB2014-11-07 20:45:38 4083 Note InnoDB: Setting log file ./ib_logfile1 size to 48 MB2014-11-07 20:45:38 4083 Note InnoDB:

8、Renaming log file ./ib_logfile101 to ./ib_logfile02014-11-07 20:45:38 4083 Warning InnoDB: New log files created, LSN=457812014-11-07 20:45:38 4083 Note InnoDB: Doublewrite buffer not found: creating new2014-11-07 20:45:38 4083 Note InnoDB: Doublewrite buffer created2014-11-07 20:45:38 4083 Note InnoDB: 128 rollback segment(s) are active.2014-11-07 20:45:38 4083 Warning InnoDB: Creating foreign key constraint system tables.2014-11-07 20:45:39 4083 Note InnoDB: Foreign key constraint system table

9、s created2014-11-07 20:45:39 4083 Note InnoDB: Creating tablespace and datafile system tables.2014-11-07 20:45:39 4083 Note InnoDB: Tablespace and datafile system tables created.2014-11-07 20:45:39 4083 Note InnoDB: Waiting for purge to start2014-11-07 20:45:39 4083 Note InnoDB: 5.6.21 started; log sequence number 02014-11-07 20:45:39 4083 Note Binlog end2014-11-07 20:45:39 4083 Note InnoDB: FTS optimize thread exiting.2014-11-07 20:45:39 4083 Note InnoDB: Starting shutdown.2014-11-07 20:45:41 4083 Note InnoDB: Shutdown completed; log sequence number 1625977OKFilling help tables.2014-11-07 20:45:41 0

《CentOS安装MySQL数据库的三种方法》由会员hs****ma分享，可在线阅读，更多相关《CentOS安装MySQL数据库的三种方法》请在金锄头文库上搜索。