安装编译工具
1
2
|
yum
install
gcc gcc-c++
yum
install
ncurses-devel
|
下载源码
1
2
3
4
5
|
mkdir
-p
/tmp
cd
/tmp
wget http:
//dev
.mysql.com
/get/Downloads/MySQL-5
.5
/mysql-5
.5.15.
tar
.gz
/from/http
:
//mysql
.he.net/
wget http:
//www
.cmake.org
/files/v2
.8
/cmake-2
.8.4.
tar
.gz
wget http:
//ftp
.gnu.org
/gnu/bison/bison-2
.5.
tar
.gz
|
由于5.5.20之后需要使用cmake对其进行configure,所以需要安装以下两个开发组件
安装cmake和bison
1
2
3
4
5
6
7
8
9
10
11
12
13
|
cd
/tmp
tar
zxvf cmake-2.8.4.
tar
.gz
cd
cmake-2.8.4
.
/bootstrap
make
make
install
cd
/tmp
tar
zxvf bison-2.5.
tar
.gz
cd
bison-2.5
.
/configure
make
make
install
|
创建MySQL用户和组
1
2
|
/usr/sbin/groupadd
mysql
/usr/sbin/useradd
-g mysql mysql
|
编译安装MySQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
cd
/tmp
tar
xvf mysql-5.5.15.
tar
.gz
cd
mysql-5.5.15/
cmake -DCMAKE_INSTALL_PREFIX=
/usr/local/mysql
\
-DMYSQL_UNIX_ADDR=
/tmp/mysql
.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS=all \
-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
make
&&
make
install
|
一些相关设置
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
chmod
+w
/usr/local/mysql
chown
-R mysql:mysql
/usr/local/mysql
ln
-s
/usr/local/mysql/lib/libmysqlclient
.so.16
/usr/lib/libmysqlclient
.so.16
mkdir
-p
/var/mysql/
mkdir
-p
/var/mysql/data/
mkdir
-p
/var/mysql/log/
chown
-R mysql:mysql
/var/mysql/
cd
support-files/
cp
my-large.cnf
/var/mysql/my
.cnf
cp
mysql.server
/etc/rc
.d
/init
.d
/mysqld
/usr/local/mysql/scripts/mysql_install_db
\
--defaults-
file
=
/var/mysql/my
.cnf \
--basedir=
/usr/local/mysql
\
--datadir=
/var/mysql/data
\
--user=mysql
chmod
+x
/etc/init
.d
/mysqld
vi
/etc/init
.d
/mysqld 和 /etc/mysql/my.ini
(编辑此文件,查找并修改以下变量内容:)
basedir=
/usr/local/mysql
datadir=
/var/mysql/data
|
加入自动启动项
1
2
|
chkconfig --add mysqld
chkconfig --level 345 mysqld on
|
启动服务
1
|
service mysqld start
|
设置管理员密码
1
|
/usr/local/mysql/bin/mysqladmin
password [new-password]
|
登陆Mysql
1
|
/usr/local/mysql/bin/mysql -root -p[刚才你设置的密码]
|