mysql源码安装

1、.Mysql源码包安装文档（单实例）系统环境：centos 5.4 x86_64Mysql版本（源码包）:5.1.58Mysql下载地址：.tw/Downloads/MySQL-5.1/mysql-5.1.58.tar.gzrootMysql-Master # mkdir /soft #创建用于存放软件包的目录，依个人习惯rootMysql-Master # cd /soft/rootMysql-Master soft#rootMysql-Master soft# wget .tw/Downloads/MySQL-5.

2、1/mysql-5.1.58.tar.gzrootMysql-Master soft# lsmysql-5.1.58.tar.gzrootMysql-Master soft# tar zxvf mysql-5.1.58.tar.gz -C /usr/src/ #解压源码包rootMysql-Master soft# groupadd mysql #创建mysql用户组rootMysql-Master soft# useradd -s /sbin/nologin -g mysql -M mysql #创建mysql用户并加入到mysql用户组，且不允许登录到shellrootMysql-Mast

3、er soft# tail -l /etc/passwd #查看创建的mysl用户（确认一下）省略部分mysql:x:500:500:/home/mysql:/sbin/nologinrootMysql-Master soft# cd /usr/src/mysql-5.1.58/rootMysql-Master mysql-5.1.58# lsrootMysql-Master mysql-5.1.58# ./configure #编译配置文件选项参数 -prefix=/usr/local/mysql #指定mysql安装路径 -with-unix-socket-path=/usr/local/

4、mysql/tmp/mysql.sock #使用unix套接字链接提高7.5%性能 -localstatedir=/usr/local/mysql/data #数据库存放目录 -enable-assembler #允许使用汇编模式(优化性能) -enable-thread-safe-client #以线程方式编译客户端 -with-mysqld-user=mysql #运行mysql用户 -with-big-tables #大表支持 -without-debug #去掉debug模式如果用-with-debug=full编译，大多数查询慢20% -with-pthread #强制使用pthre

5、ad库(posix线程库) -with-extra-charsets=complex #字符集支持 -with-readline #支持行编辑库 -with-ssl #开启ssl支持 -with-embedded-server #建立嵌入式服务器 -enable-local-infile #让mysql支持从本地文件导入数据库 -with-plugins=partition,innobase #支持存储引擎组件 -with-plugins-PLUGIN #支持存储引擎组件 -with-mysqld-ldflags=-all-static -with-client-ldflags=-all-st

6、atic#以静态方式编译客户端和服务端，能提高13%性能rootMysql-Master mysql-5.1.58# make#编译rootMysql-Master mysql-5.1.58# make install#安装rootMysql-Master mysql-5.1.58# ls -l support-files/*.cnf-rw-r-r- 1 root root 4714 Jun 19 00:58 support-files/f-rw-r-r- 1 root root 19763 Jun 19 00:58 support-files/my-innodb-heav

7、y-4G.cnf-rw-r-r- 1 root root 4688 Jun 19 00:58 support-files/f-rw-r-r- 1 root root 4699 Jun 19 00:58 support-files/f-rw-r-r- 1 root root 2467 Jun 19 00:58 support-files/frootMysql-Master mysql-5.1.58# /bin/cp support-files/f /etc/f#拷贝配置文件为/etc/f

8、rootMysql-Master mysql-5.1.58# ls -l /etc/f -rw-r-r- 1 root root 2467 Jun 19 01:12 /etc/frootMysql-Master mysql-5.1.58# mkdir -p /usr/local/mysql/data#创建mysql数据目录rootMysql-Master mysql-5.1.58# chown -R mysql /usr/local/mysqlrootMysql-Master mysql-5.1.58#rootMysql-Master mysql-5.1.58# /usr/

9、local/mysql/bin/mysql_install_db -user=mysql#初始化数据库（生成初始数据库）rootMysql-Master mysql-5.1.58# /usr/local/mysql/bin/mysqld_safe &#初始启动mysqlrootMysql-Master mysql-5.1.58# netstat -lnt | grep 3306tcp 0 0 :3306 :* LISTEN rootMysql-Master mysql-5.1.58#rootMysql-Master mysql-5.1.58# cp support-

10、files/mysql.server /usr/local/mysql/bin/#拷贝启动脚本到/usr/local/mysql/bin下rootMysql-Master mysql-5.1.58# chmod 700 /usr/local/mysql/bin/mysql.serverrootMysql-Master mysql-5.1.58#rootMysql-Master mysql-5.1.58# echo export PATH=$PATH:/usr/local/mysql/bin /etc/profile#加入环境变量rootMysql-Master mysql-5.1.58# so

11、urce /etc/profilerootMysql-Master mysql-5.1.58# cp support-files/mysql.server /etc/init.d/mysqld #设置为service启动模式rootMysql-Master mysql-5.1.58# chmod 700 /etc/init.d/mysqldrootMysql-Master mysql-5.1.58# chkconfig -add mysqld#将mysql服务加入到开机自启项rootMysql-Master mysql-5.1.58# chkconfig mysqld on#设置mysql服务

12、开机自启rootMysql-Master mysql-5.1.58#rootMysql-Master mysql-5.1.58# service mysqld restart#重启mysql默认mysql安装好是没有root密码的，直接mysql命令就能进入数据库，为了安全给root设置密码：rootMysql-Master mysql-5.1.58# cdrootMysql-Master # mysqladmin -u root password 111111#给root设密码rootMysql-Master #rootMysql-Master # mysql -u root -p#设置了密码再进数据库就得加-p了Enter password: #输入密码即可进入数据库，密码为密文Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 2Server version: 5.1.58 Source distributionCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.This software comes with ABSOLUTELY NO