准备工作: 新建用户和用户组 groupadd mysql useradd -g mysql mysql 1:下载: bison-2.4.2.tar.bz2 cmake-2.8.3.tar.gz make-3.82.tar.gz bzr-2.3b5.tar.gz mysql-5.5.8.tar.gz 2:解压安装前3个包 tar zxvf cmake-2.8.3.tar.gz cd cmake-2.8.3 ./configure make make install tar zxvf make-3.82.tar.gz cd make-3.8.2 ./configure make make install tar jxvf bison-2.4.2.tar.bz2 cd bison-2.4.2 ./configure make make install 3:解压mysql-5.5.8.tar.gz tar zxvf mysql-5.5.8.tar.gz cd mysql-5.5.8 cmake . \ -DCMAKE_INSTALL_PREFIX=/mysql/mysqldir \ -DMYSQL_DATADIR=/mysql/mysqldir/data \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DMYSQL_TCP_PORT=3306 \ -DMYSQL_UNIX_ADDR==/mysql/mysqldir/data/mysql.sock \ -DMYSQL_USER=mysql \ -DWITH_DEBUG=0 报错(如无报错直接make & make install 即可): CMake Error at cmake/readline.cmake:82 (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:126 (FIND_CURSES) cmake/readline.cmake:216 (MYSQL_USE_BUNDLED_LIBEDIT) CMakeLists.txt:256 (MYSQL_CHECK_READLINE) -- Configuring incomplete, errors occurred! 缺少包:ncurses-devel 解决: 到安装光盘或者网上DOWN相应的包 安装: rpm -ivh ncurses-devel*.rpm rm -f CMakeCache.txt cmake . \ -DCMAKE_INSTALL_PREFIX=/data/mysql \ -DMYSQL_DATADIR=/data/mysql/data \ -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/data \
-DMYSQL_USER=mysql
make && make install
完成后进入MYSQL安装目录 cd /mysql/mysqldir cp support-files/my-huge.cnf /etc/my.cnf
vi /etc/my.cnf 将数据目录和套接字文件修改为实际值.
在[mysqld]字段下添加如下内容
datadir = /data/mysql/data
修改权限 chown mysql:mysql /etc/my.cnf chown -R mysql:mysql /mysql/mysqldir
安装初始化数据库
cd /data/mysql cp scripts/mysql_install_db .
./mysql_install_db --user=mysql --datadir=/data/mysql/data
准备启动脚本:
cp support-files/mysql.server /etc/init.d/mysqld
加入服务队列
chkconfig --add mysqld
设置开机自动启动
chkconfig mysqld on