centos源码编译安装mysql-5.5.13

转载于http://www.falcon-monitor.com/blog/235.html

安装MySQL需要的环境

apt-get install cmake
apt-get install bison
apt-get install libncurses5-dev

下载MySQL 推荐大家去搜狐或网易的镜像下载

cd /data/software/db/
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.13.tar.gz/from/http://mysql.ntu.edu.tw/

添加用户

/sbin/groupadd mysql
/sbin/useradd -g mysql mysql

解压

tar zxvf mysql-5.5.13.tar.gz
cd mysql-5.5.13
rm CMakeCache.txt
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/webserver/mysql/ -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci  -DMYSQL_USER=mysql  -DWITH_DEBUG=0

参数说明：

-DCMAKE_INSTALL_PREFIX=/usr/local/webserver/mysql/  #安装目录
-DWITH_INNOBASE_STORAGE_ENGINE=1  #安装innodb存储引擎
-DENABLED_LOCAL_INFILE=1 #允许MySQL从文件中加载数据
-DEXTRA_CHARSETS=all  #全字符集支持
-DDEFAULT_CHARSET=utf8 #默认编码utf8
-DDEFAULT_COLLATION=utf8_general_ci #表的默认编码为utf8_general_ci
-DMYSQL_USER=mysql #用户为MySQL
-DWITH_DEBUG=0 #关闭debug

初始化数据库

mkdir -p /data/mysql/3306/data/
chown -R mysql:mysql /data/mysql/3306/data/
/usr/local/webserver/mysql/scripts/mysql_install_db –basedir=/usr/local/webserver/mysql –datadir=/data/mysql/3306/data –user=mysql

配置my.cnf

cp /data/software/db/mysql-5.5.13/support-files/my-medium.cnf /data/mysql/3306/my.cnf

启动mysql

/bin/sh /usr/local/webserver/mysql/bin/mysqld_safe –defaults-file=/data/mysql/3306/my.cnf 2>&1 > /dev/null &

进入MySQL，更改Root密码及添加用户

直接回车进入Root

/usr/local/webserver/mysql/bin/mysql -uroot -p
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION ;
Query OK, 0 rows affected (0.00 sec)

错误信息：

-- MySQL 5.5.16
-- Could NOT find Curses (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH) 
CMake Error at cmake/readline.cmake:83 (MESSAGE):
  Curses library not found.  Please install appropriate package,

      remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
Call Stack (most recent call first):
  cmake/readline.cmake:118 (FIND_CURSES)
  cmake/readline.cmake:214 (MYSQL_USE_BUNDLED_READLINE)
  CMakeLists.txt:257 (MYSQL_CHECK_READLINE)

-- Configuring incomplete, errors occurred!

解决方案：删除CMakeCache.txt文件(#rm  CMakeCache.txt),然后安装ncurses-devel(#yum install ncurses-devel)

-- MySQL 5.5.16
Warning: Bison executable not found in PATH
-- Configuring done
-- Generating done
CMake Warning:
  Manually-specified variables were not used by the project:

    MYSQL_USER
    WITH_MEMORY_STORAGE_ENGINE

-- Build files have been written to: /home/MoFei/temp/mysql-5.5.16

解决方案：删除CMakeCache.txt文件(#rm  CMakeCache.txt),然后安装Bison(#yum install bison)

启动错误：

InnoDB: Error: pthread_create returned 11

解决方案：

[mysqld]添加
default-storage-engine=MyISAM
loose-skip-innodb

参考：http://ideas.spkcn.com/technology/database/259.html