安装mysql前要做的准备工作:
安装编译工具 和mysql所需的系统库
yum -y install gcc
yum–y install gcc-c++
yum -y install ncurses-devel
进入mysql源码包:
安装mysql5.5.19所需的工具有两种方法:
(1) 第一种比较简单直接用yum安装 yum –y install m4-1.4.16 bison cmake
(2) 第二种源码安装:
首先安装m4-1.4.16
Wget http://ftp.gnu.org/gnu/m4/m4-1.4.16.tar.gz
tar zxvf m4-1.4.16.tar.gz
cd m4-1.4.16
./configure
make
make install
其次安装bison
wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz
tar zxvf bison-2.5.tar.gz
cd bison-2.5
./configure
make
make install
再是安装cmake
wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
tar zxvf cmake-2.8.4.tar.gz
cd cmake-2.8.4
./bootstrap
gmake
gmake install
在Linux系统中添加用户和组
Groupaddmysql
Useradd–g mysql mysql
以上工作做完后开始安装mysql.5.5.19
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock\
-DDEFAULT_CHARSET=utf8\
-DDEFAULT_COLLATION=utf8_general_ci\
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk\
-DWITH_MYISAM_STORAGE_ENGINE=1\
-DWITH_INNOBASE_STORAGE_ENGINE=1\
-DWITH_MEMORY_STORAGE_ENGINE=1\
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1\
-DMYSQL_DATADIR=/var/mysql/data\
-DMYSQL_USER=mysql
chmod +w /usr/local/mysql
chown -Rmysql:mysql /usr/local/mysql
ln -s /usr/local/mysql/lib/libmysqlclient.so.18/usr/lib/libmysqlclient.so.18
mkdir -p /var/mysql/
mkdir -p /var/mysql/data/
mkdir -p /var/mysql/log/
chown -R mysql:mysql /var/mysql/
cp my-large.cnf /var/mysql/my.cnf
/usr/local/mysql/scripts/mysql_install_db\
--defaults-file=/var/mysql/my.cnf\
--basedir=/usr/local/mysql\
--datadir=/var/mysql/data\
--user=mysql
或者直接添加几个软连接让这些工具可以直接用,如下
ln -s/usr/local/mysql/bin/mysql /usr/bin
ln -s/usr/local/mysql/bin/mysqldump /usr/bin
ln -s/usr/local/mysql/bin/mysqladmin /usr/bin
cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
vi /etc/init.d/mysqld (编辑此文件,查找并修改以下变量内容:)
basedir=/usr/local/mysql
datadir=/var/mysql/data
chkconfig --add mysqld
chkconfig --level345 mysqld on