一、虚拟环境准备
虚拟机：vmware workstation
system：centos6.0（64bit）基本安装
二、相关组件下载地址
cmake：http://www.cmake.org/
bison：http://www.gnu.org/s/bison/
mysql：http://www.mysql.com/
m4：http://www.gnu.org/s/m4/
三、组件下载、安装
[root@centos ~]# cd /usr/src/
[root@centos src]# wget http://www.cmake.org/files/v2.8/cmake-2.8.5.tar.gz
[root@centos src]# wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz
[root@centos src]# wget http://gd.tuwien.ac.at/db/mysql/downloads/mysql-5.5/mysql-5.5.16.tar.gz
[root@centos src]# wget http://ftp.gnu.org/gnu/m4/m4-1.4.16.tar.gz
⑴cmake 、bison安装
[root@centos src]# tar -zxvf cmake-2.8.5.tar.gz
[root@centos src]# cd cmake-2.8.5
[root@centos cmake-2.8.5]# ./bootstrap
[root@centos cmake-2.8.5]# make
[root@centos cmake-2.8.5]# make install
[root@centos cmake-2.8.5]# cmake --version
cmake version 2.8.5
[root@centos src]# tar -zxvf bison-2.5.tar.gz
[root@centos src]# cd bison-2.5
[root@centos bison-2.5]#./configure
[root@centos bison-2.5]#make
[root@centos bison-2.5]#make install
[root@centos bison-2.5]# bison --version
bison (gnu bison) 2.4.1
written by robert corbett and richard stallman.
copyright (c) 2008 free software foundation, inc.
this is free software; see the source for copying conditions. there is no
warranty; not even for merchantability or fitness for a particular purpose.
⑵mysql 安装
[root@centos src]# tar -zxvf mysql-5.5.16.tar.gz
[root@centos src]# cd mysql-5.5.16
[root@centos mysql-5.5.16]# groupadd mysql
[root@centos mysql-5.5.16]# useradd -g mysql mysql
[root@centos mysql-5.5.16]# 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,gb2312 /
> -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
相同功能
[root@centos mysql-5.5.16]# 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,gb2312 -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
[root@centos mysql-5.5.16]# make
[root@centos mysql-5.5.16]# make install
[root@centos mysql-5.5.16]# chmod +w /usr/local/mysql
[root@centos mysql-5.5.16]# chown -r mysql:mysql /usr/local/mysql
[root@centos mysql-5.5.16]# cd /usr/local/mysql/lib
[root@centos lib]# ls
libmysqlclient.a libmysqlclient_r.so.18 libmysqlclient.so.18 plugin
libmysqlclient_r.a libmysqlclient_r.so.18.0.0 libmysqlclient.so.18.0.0
libmysqlclient_r.so libmysqlclient.so libmysqlservices.a
[root@centos lib]# ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib/libmysqlclient.so.18 32bit
[root@centos lib]# ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18 64bit
[root@centos src]# cd /usr/src/mysql-5.5.16
[root@centos mysql-5.5.16]# mkdir -p /var/mysql/
[root@centos mysql-5.5.16]# mkdir -p /var/mysql/data/
[root@centos mysql-5.5.16]# mkdir -p /var/mysql/log/
[root@centos mysql-5.5.16]# chown -r mysql:mysql /var/mysql/
[root@centos mysql-5.5.16]# cp /usr/src/mysql-5.5.16/support-files/my-large.cnf /var/mysql/my.cnf
[root@centos mysql-5.5.16]# cp /usr/src/mysql-5.5.16/support-files/mysql.server /etc/init.d/mysqld
[root@centos mysql-5.5.16]# /usr/local/mysql/scripts/mysql_install_db /
> --defaults-file=/var/mysql/my.cnf /
> --basedir=/usr/local/mysql /
> --datadir=/var/mysql/data /
> --user=mysql
相同功能
[root@centos mysql-5.5.16]# /usr/local/mysql/scripts/mysql_install_db --defaults-file=/var/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/var/mysql/data --user=mysql
[root@centos mysql-5.5.16]# chmod +x /etc/init.d/mysqld
[root@centos mysql-5.5.16]# vim /etc/init.d/mysqld （修改）
basedir=/usr/local/mysql
datadir=/var/mysql/data
[root@centos mysql-5.5.16]# chkconfig --add mysqld
[root@centos mysql-5.5.16]# chkconfig --level 345 mysqld on
[root@centos mysql-5.5.16]# service mysqld start
starting mysql.. success!
[root@centos tmp]# mysqladmin -u root -p password 123.com
enter password:
四、fqa常见问题
①[root@centos mysql-5.5.16]# service mysqld start
starting mysql.. error! the server quit without updating pid file (/var/lib/mysql/centos.lnmp.pid).
解决方案：
[root@centos mysql-5.5.16]# mv /etc/my.cnf my.cnf.bakcup
②[root@centos mysql-5.5.16]# mysqladmin -u root -p password 123.com
enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'can't connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (2)'
check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
解决方案：
[root@centos mysql-5.5.16]# vim /var/mysql/my.cnf
socket =/tmpl/mysql.sock 修改socket = /var/lib/mysql/mysql.sock
[root@centos tmp]# ln -s /tmp/mysql.sock /var/lib/mysql/
[root@centos tmp]# mysqladmin -u root -p password 123.com
enter password:
联系：qq:64324613
本文出自 “13975309974” 博客
bitscn.com