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-h

7、eavy-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/my.

8、cnfrootmysql-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# /u

9、sr/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 suppo

10、rt-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#

11、 source /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#设置mysq

12、l服务开机自启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#设

13、置了密码再进数据库就得加-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 warranty. this is fre