转载于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