-DMYSQL_USER=mysql \
-DEXTRA_CHARSETS=all \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1
不带换行符的(只有一行)
4.1参数：-DWITHOUT_PARTITION_STORAGE_ENGINE=1
在64位机器上编译不过，会出现如下错误:(64位机器的浮点数运算上出错,导致找不着相应的函数)
libsql.a(handler.cc.o): In function`get_ha_partition(partition_info*)’:
/data/mysql-5.5.14/sql/handler.cc:269: undefined reference to`ha_partition::ha_partition(handlerton*, partition_info*)’
/data/mysql-5.5.14/sql/handler.cc:271: undefined reference to`ha_partition::initialize_partition(st_mem_root*)’
libsql.a(sql_partition_admin.cc.o): In function`Alter_table_truncate_partition_statement::execute(THD*)’:
/data/mysql-5.5.14/sql/sql_partition_admin.cc:165: undefinedreference to `ha_partition::truncate_partition(Alter_info*, bool*)’
collect2: ld returned 1 exit status
make[2]: *** [sql/mysqld] Error 1
make[1]: *** [sql/CMakeFiles/mysqld.dir/all] Error 2
make: *** [all] Error 2
4.2参数:-DWITH_SSL=bundled
自mysql5.6.*及以后的版本都要默认带上此参数，否则编译不过 ,相关贴子:
https://github.com/santisaez/powerstack/issues/49
Use bundled SSL on CentOS-5
4.3安装执行
# tar xvf mysql-5.5.10.tar.gz
# cd mysql-5.5.10
# cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5 -DSYSCONFDIR=/usr/local/mysql5.5/etc-DMYSQL_DATADIR=/usr/local/mysql5.5/data -DMYSQL_TCP_PORT=3306-DMYSQL_UNIX_ADDR=/usr/local/mysql5.5/mysqld.sock -DMYSQL_USER=mysql-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all-DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1-DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_SSL=bundled
#make
#make install
5 设置
#cd support-files/
拷贝配置文件:
#cp my-default.cnf /etc/my.cnf
设置开机自动启动
#cp mysql.server /etc/rc.d/init.d/mysqld
#/usr/local/mysql5.5/scripts/mysql_install_db--defaults-file=/etc/my.cnf --basedir=/usr/local/mysql5.5--datadir=/usr/local/mysql5.5data --user=mysql
5.2设置
#vi /etc/init.d/mysqld（编辑此文件，查找并修改以下变量内容：）
basedir=/usr/local/mysql5.5
datadir=/var/mysql5.5/data
加入启动项：
#chkconfig --add mysqld
#chkconfig --level 345 mysqld on
5.3启动服务
#service mysqld start
如果文件夹：/usr/local/mysql5.5是只读的，会报错:
…
…
2013-04-08 11:12:45 7886 [Note] IPv6 is notavailable.
2013-04-08 11:12:45 7886 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2013-04-08 11:12:45 7886 [Note] Server socketcreated on IP: '0.0.0.0'.
2013-04-08 11:12:45 7886 [ERROR] Can't startserver : Bind on unix socket: Permission denied
2013-04-08 11:12:45 7886 [ERROR] Do youalready have another mysqld server running on socket:/usr/local/mysql5.5/mysqld.sock
2013-04-08 11:12:45 7886 [ERROR] Aborting
…
2013-04-08 11:12:45 7886 [Note] InnoDB:Starting shutdown...
2013-04-08 11:12:47 7886 [Note] InnoDB:Shutdown completed; log sequence number 1626077
2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'BLACKHOLE'
2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'PERFORMANCE_SCHEMA'
2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'ARCHIVE'
2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'CSV'
2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'MRG_MYISAM'
2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'MyISAM'
2013-04-08 11:12:47 7886 [Note] Shutti