Linux 下的Mysql 5.5.8原码编译, 使用了新的cmake编译方式大家可能不习惯和之前常用 的方式有所不同 具体操作步骤如下:
Setup 1:
检查是否安装好了cmake 直接用 cmake -i看看是否有效如果无效请用下面方式安装:
wget -c http://www.cmake.org/files/v2.8/cmake-2.8.3.tar.gz
tar -zxvf cmake-2.8.3.tar.gz
cd cmake-2.8.3
./bootstrap
./configure
make && make install
Setup 2:
安装MYSQL 5.5.8
wget -c http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/mysql-5.5.8.tar.gz
tar -zxvf mysql-5.5.8.tar.gz
cd mysql-5.5.8/
#cmake的编译方式 新旧参数对比表请查看 http://forge.mysql.com/wiki/Autotools_to_CMake_Transition_Guide
cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DWITH_SSL=system -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -LH
make && make install
慢长的等待过后终于完成了
groupadd mysql
useradd -g mysql mysql
cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
vim /etc/my.cnf #需要加入basedir,和datadir否则会出问题
[mysqld]
basedir =/usr/local/mysql
datadir =/usr/local/mysql/data
/usr/local/mysql/scripts/mysql_install_db –user=mysql
chown -R mysql /usr/local/mysql/data
chgrp -R mysql /usr/local/mysql/.
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chmod 755 /etc/init.d/mysql
chkconfig –level 345 mysql on
echo “/usr/local/mysql/lib/mysql” >> /etc/ld.so.conf
echo “/usr/local/lib” >>/etc/ld.so.conf
ldconfig
/etc/init.d/mysql start
/usr/local/mysql/bin/mysqladmin -u root password 你的MYSQL密码
/etc/init.d/mysql restart
/etc/init.d/mysql stop
OK终于完成~
常见问题：
1. /etc/init.d/mysql: line 256: my_print_defaults: command not found
解决方法: 检查/etc/my.cnf是否存在datadir和basedir如果没有请增加 datadir和basedir目录路径.
如下
[mysqld]
port = 3306
basedir =/usr/local/mysql
datadir =/usr/local/mysql/data