Mysql-5.5源码安装

MySQL 5.5 版本，编译安装使用 cmake 。

cmake 安装之前，如果已经运行过 cmake，尝试运行下面的命令来避免冲突，# make clean #find / -iname “cmakecache.txt” | rm

编译安装的时候，需要指定 DDEFAULT_CHARET=utf8 ，指定字符集。

---

Mysql_5.5源码安装步骤

1.编译安装5.5

# yum install -y make cmake gcc-c++ bison ncurses# wget , tar # groupadd mysql# useradd -g mysql -s /sbin/nologin -M mysql# mkdir /data/mysql# cd /usr/local/mysql# cmake  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/data/mysql/ \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \-DWITH_DEBUG=0 \-DWITH_SSL=yes \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DENABLED_LOCAL_INFILE=1 \-DMYSQL_TCP_PORT=3306# make ; echo $? ; make install ; echo $?

---

2.安装数据库

# cd /usr/local# chown -R mysql:mysql mysql# cd mysql# ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql# chown -R root .# chown -R mysql /data/mysql

---

3.编辑配置文件并启动

# cp support-files/my-large.cnf /etc/my.cnf# bin/mysqld_safe --user=mysql &# cp support-files/mysql.server /etc/init.d/mysqld# chmod +x !$# chkconfig -add mysqld# chkconfig mysqld on# /etc/init.d/mysqld start