自:http://www.itpub.net/forum.php?mod=viewthread&tid=1829546&highlight=��װ
MySQL的rpm和二进制安装
需要用户在服务器上手动编译.二进制的安装是由mysql官方已经编译好,用户只需要简单的增加mysql用户和组
再建授对表就可以使用了,优点是官方编译,稳定性相对自己编译有保证.
[root@localhost dongdongtang]# uname -r
2.6.18-194.el5
[root@localhost soft]# rpm -Uvh MySQL-server-5.6.14-1.rhel5.x86_64.rpm
安装过程会自动创建mysql用户和mysql组,datadir目录会被安装到/var/lib/mysql,默认的pid,sockect和err文件都会存放在
这个目录中.
二进程制文件安装,一般都是下载的一个压缩包文件.如我下载过来的是mysql.sourc3.zip,
[root@asm temp]# unzip mysql.source.zip
Archive:
extracting: mysql-advanced-5.6.14-linux-glibc2.5-x86_64.tar.gz
extracting: mysql-advanced-5.6.14-linux-glibc2.5-x86_64.tar.gz.asc
extracting: mysql-advanced-5.6.14-linux-glibc2.5-x86_64.tar.gz.md5
extracting: README.txt
再次解压
[root@asm temp]# tar -zxvf mysql-advanced-5.6.14-linux-glibc2.5-x86_64.tar.gz
mysql-advanced-5.6.14-linux-glibc2.5-x86_64/bin/mysql_convert_table_format
mysql-advanced-5.6.14-linux-glibc2.5-x86_64/bin/mysql_client_test
mysql-advanced-5.6.14-linux-glibc2.5-x86_64/bin/mysqlhotcopy
................................................
增加mysql组和用户
[root@asm temp]# groupadd mysql
[root@asm temp]# useradd -g mysql mysql
[root@asm temp]# passwd mysql
把解压过来的mysql所有文件,复制到安装目录中,
[root@asm temp]# mv mysql-advanced-5.6.14-linux-glibc2.5-x86_64 /usr/local/mysql
确认一下文件是全部存在的
[root@asm temp]# cd /usr/local/mysql
[root@asm mysql]# ls
bin
创建数据目录和初始化系统表
[root@asm mysql]# pwd
/usr/local/mysql
[root@asm mysql]# /usr/local/mysql/scripts/mysql_install_db --user=mysql
Installing MySQL system tables...2013-11-19 06:15:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-11-19 06:15:57 4019 [Note] InnoDB: The InnoDB memory heap is disabled
2013-11-19 06:15:57 4019 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-11-19 06:15:57 4019 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-11-19 06:15:57 4019 [Note] InnoDB: Using Linux native AIO
................................................................
New default config file was created as ./my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings
同时在/usr/local/mysql目录中生成my.cnf参数文件
[root@asm mysql]# ls
bin
更改/usr/local/mysql所有者为mysql:mysql
[root@asm mysql]# chown -R mysql:mysql /usr/local/mysql
安装完成,现在可以启动mysql服务器了
[root@asm mysql]# /usr/local/mysql/bin/mysqld_safe --user=mysql --group=mysql
131119 06:20:26 mysqld_safe Logging to '/usr/local/mysql/data/asm.err'.
131119 06:20:26 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
[root@asm ~]# netstat -nltp | grep 3306
tcp
服务器启动成功。恭喜你现在有一台MySQL数据库服务器了.
MySQL源码安装
检查必需的包
[root@localhost soft]# rpm -q make
make-3.81-3.el5
[root@localhost soft]# rpm -q gcc
gcc-4.1.2-48.el5
[root@localhost soft]# rpm -q perl
perl-5.8.8-27.el5
[root@localhost soft]# rpm -q libaio-devel
libaio-devel-0.3.106-5
安装cmake,gpref和ncruses-devel
[root@localhost soft]# yum install gperf.x86_64
..............................................
Installed:
Complete!
[root@localhost oracle]# yum install ncurses-devel.x86_64
[root@localhost cmake-2.8.12.1]# tar -xzvf cmake-2.8.12.1.tar.gz
[root@localhost cmake-2.8.12.1]# ./configure
[root@localhost cmake-2.8.12.1]# gmake
oot@localhost cmake-2.8.12.1]# make install
开始编译MySQL源码
[root@localhost mysql-5.6.14]# cmake .
[root@localhost mysql-5.6.14]# make
[root@localhost mysql-5.6.14]# make install DESTDIR="/opt/mysql"