1
2
|
#Mysql需要安装bison、ncurses否则会提示警告,mysql开启openssl等,故安装zlib和openssl。
yum -y
install
gcc
make
ncurses-devel zlib zlib-devel openssl openssl-devel bison wget
|
1
2
3
4
5
|
wget http:
//www.cmake.org/files/v2.8/cmake-2.8.7.tar.gz
tar -zvxf cmake-
2.8
.
7
.tar.gz
cd cmake-
2.8
.
7
./configure
gmake && gmake install
|
1
2
3
4
5
6
7
8
9
10
11
|
wget http:
//downloads
.mysql.com
/archives/mysql-5
.5
/mysql-5
.5.30.
tar
.gz
tar
-zvxf mysql-5.5.30.
tar
.gz
cd
mysql-5.5.30
cmake . -DCMAKE_INSTALL_PREFIX=
/usr/local/mysql
\
-DMYSQL_DATADIR=
/var/lib/mysql
-DINSTALL_SBINDIR=
/usr/sbin/
\
-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all-DWITH_SSL=system \
-DWITH_DEBUG=0
make
&&
make
install
# 备注:对于csv,myisam,myisammrg,heap在cmake中是不需要明确指定存储引擎的名称,因为它们是强制性安装。
|
1
2
3
4
5
|
mkdir
/var/lib/mysql
/var/log/mysql
#创建mysql组和mysql用户
groupadd mysql;
useradd
-r -g mysql mysql 或
useradd
-s
/sbin/nologin
mysql
chmod
+w
/usr/local/mysql
chown
-R mysql:mysql
/usr/local/mysql
/var/lib/mysql
/var/log/mysql
|
1
2
3
4
|
M5.1版本和5.5版本的初始化数据库略微不同,5.1的mysql_install_db在bin目录下,5.5在scripts目录下。
/usr/local/mysql/scripts/mysql_install_db
--user=mysql --pid-
file
=
/var/lib/mysql/mysql
.pid --datadir=
/var/lib/mysql/
--basedir=
/usr/local/mysql
赋权:
chown
-R mysql:mysql
/var/lib/mysql
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
将解压后的
tar
包下的upport-files
/my-medium
.cnf复制
/etc
并替换为
/my
.cnf. (根据需求复制相应配置)
cp
support-files
/my-medium
.cnf
/etc/my
.cnf
#在[client]下修改socket值为/var/lib/mysql/mysql.sock,
修改mysqld下的socket值为
/var/lib/mysql/mysql
.sock,并指定mysql目录、mysql数据目录、mysql错误日志目录,配置如下,并设定数据库编码为UTF-8修改后保存退出
[client]
socket =
/var/lib/mysql/mysql
.sock
# The MySQL server
[mysqld]
port = 3306
socket =
/var/lib/mysql/mysql
.sock
basedir =
/usr/local/mysql
datadir =
/var/lib/mysql/
log-error =
/var/log/mysql/mysql-error
.log
pid-
file
=
/var/lib/mysql/mysql
.pid
character-
set
-server = utf8
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
启动mysql
/usr/local/mysql/bin/mysqld_safe
&
ps
-A|
grep
mysql
设置mysql开机启动。
cp
support-files
/mysql
.server
/etc/init
.d
/mysql
chmod
+x
/etc/init
.d
/mysql
cd
/etc/mysql
chkconfig --add mysql
chkconfig mysql on
测试mysql是否能启动、暂停、重启
service mysql restart (start|stop|restart)
或
/etc/init
.d
/mysql
restart (start|stop|restart)
将部分mysql命令加入到
/usr/bin
中:
ln
/usr/local/mysql/bin/mysql
/usr/bin/
;
ln
/usr/local/mysql/bin/mysqladmin
/usr/bin/
;
ln
/usr/local/mysql/bin/mysqldump
/usr/bin/
|