创建mysql用户 [root@xuhost opt]# useradd -g mysql mysql3307 -s /bin/nologin -d /usr/local/mysql3307
创建数据目录 [root@xuhost opt]# mkdir /mysqldata/dirdata/mysql3307 [root@xuhost opt]# chown mysql.mysql -R /mysqldata/dirdata/mysql3307
安装 cmake
1
2
3
4
5
6
7
8
9
|
[root@xuhost opt] # wget http: //www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
[root@xuhost opt] # tar zxvf cmake- 2.8.4.tar.gz
[root@xuhost opt] # ./configure
[root@xuhost opt] # cd cmake- 2.8.4
[root@xuhost cmake- 2.8.4 ] # make install
|
安装mysql 5.5.9
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
[root@xuhost opt] # tar zxvf mysql- 5.5.9.tar.gz
[root@xuhostopt] # cd mysql- 5.5.9
[root@xuhost mysql- 5.5.9 ] # cmake . \
-DCMAKE_INSTALL_PREFIX= /mysqldata/mysql3307/ \
-DMYSQL_DATADIR= /mysqldata/dirdata/mysql3307 \
-DWITH_INNOBASE_STORAGE_ENGINE= \
-DENABLED_LOCAL_INFILE= \
-DMYSQL_TCP_PORT= \
-DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8-general_ci \
-DMYSQL_UNIX_ADDR= /mysqldata/dirdata/mysql3307 /mysql .sock \
-DMYSQL_USER=mysql3307 \
-DWITH_DEBUG=
[root@xuhost mysql- 5.5.9] # make
[root@xuhost mysql- 5.5.9] # make install
|
复制配置文件
1
|
[root@xuhost mysql- 5.5.9] # cp support-files/my-medium.cnf /etc/my.cnf
|
复制启动脚本
1
2
3
|
[root@xuhost mysql- 5.5.9] # cp support-files/mysql.server /etc/init.d/mysqld
[root@xuhost mysql- 5.5.9 ] # chmod /etc/init.d/mysqld
|
初始化数据库 (进到安装目录)
1
|
[root@xuhost mysql5. 5.9 ] # ./scripts/mysql_install_db –user=mysql –ldata=/ var /mysql
|
启动数据库
1
|
[root@xuhost mysql5. 5.9 ] # /etc/init.d/mysqld start
|
Myslq 5.5 . 以上版本编译出现错误汇总:
CMake Warning: The var iable, 'MYSQL_USER' , specified manually, was not used during the generation.
需要把预编译里面的MYSQL_USER去掉,即可预编译成功!