CentOS5.8下源码安装MySQL5.5实践笔记

• 源码安装系统软件要求

  1. CMake

  2. A good make program

  3. A working ANSI C++ compiler

  4. Perl is needed if you intend to run test scripts.

  
  

• 安装CMake
  

  cd /home  #进入软件包存放目录
  tar zxvf cmake-2.8.10.tar.gz  #解压
  cd cmake-2.8.10 #进入目录
  ./configure #配置
  make #编译
  make install #安装

  
  

• 安装MySQL

  1. System Pretask
     

     groupadd mysql #添加mysql组
     useradd -g mysql mysql -s /bin/nologin #创建用户mysql并加入到mysql组，不允许mysql用户直接登录系统
     mkdir -p /data/mysql #创建MySQL数据存放目录
     chown -R mysql:mysql /data/mysql #设置MySQL数据库存放目录权限
     mkdir -p /opt/mysql #创建MySQL安装路径

     
     

  2. Compile & Install MySQL
     

     cd /home/mysql-5.5.31
     cmake . -DCMAKE_INSTALL_PREFIX=/opt/mysql \
     -DMYSQL_DATADIR=/data/mysql \
     -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
     -DMYSQL_USER=mysql \
     -DSYSCONFDIR=/etc
     make
     make install

     
     

  3. Postinstallation setup
     

     cd /opt/mysql
     chown -R mysql:mysql .
     scripts/mysql_install_db \
     --defaults-file=/etc/my.cnf
     --basedir=/opt/mysql \
     --datadir=/data/mysql \
     --user=mysql
     cd /data/mysql
     chown -R mysql:mysql .
     cp support-files/my-medium.cnf /etc/my.cnf

     
     

  4. Configure MySQL Service & Start Onboot
     

     cp support-files/mysql.server /etc/init.d/mysqld
     chmod +x /etc/init.d/mysqld
     vim /etc/init.d/mysqld
      basedir=/opt/mysql
      datadir=/data/mysql
     chkconfig --add mysqld
     chkconfig --level 345 mysqld on
     vim /etc/profile
      export PATH=$PATH:/opt/mysql/bin

     
     

  5. Start & Stop Test
     

     bin/mysqld_safe --user=mysql &
     bin/mysqladmin version
     bin/mysqladmin variables
     bin/mysqladmin -uroot shutdown

     
     

• 如果Cmake失败的话
  

  make clean
  rm CMakeCache.txt