mysql 5.5.10_mysql 5.5.10 安装方法

首先，需要下载安装Cmake;

wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz

安装cmake;

tar xvzf cmake-2.8.4.tar.gz

./configure

make

make install

下载mysql,可以去官方网站找到你所需要的；

wget ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.5/mysql-5.5.9.tar.gz

编译安装mysql

cd mysql5.5.9

/usr/local/bin/cmake   . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysqld.sock -DMYSQL_TCP_PORT=3306 -DMYSQL_DATADIR=/usr/local/mysql/data  -DWITH_DEBUG=0 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1     -DWITH_INNODB_STORAGE_ENGINE=1  -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1

make && make install

groupadd mysql

useradd -g mysql mysql

chown -R mysql /usr/local/mysql/var

chgrp -R mysql /usr/local/mysql/

cd /usr/local/mysql/scripts/

./mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

/usr/local/mysql/bin/mysqld_safe --user=mysql &

#增加服务，需修改mysqld中的basedir和datadir

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

# chmod很重要，不然会启动不了

chmod 755 /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig --level 2345 mysqld on

#配置文件增加utf8

vi /etc/my.cnf

16.#增加以下内容

[mysqld]

character-set-server = utf8

collation_server = utf8_unicode_ci

service mysqld start