windows下jira confluence迁移到linux

A：安装系统

………..

B： mysql 5.5.x安装

mysql 5.5.x版本需要cmake编译安装

#创建用户和用户组

groupadd -g 3306 mysql;useradd -u 3306 -g mysql -M -s /sbin/nologin mysql

#创建mysql安装目录

mkdir /usr/local/mysql/

#创建数据目录与赋予数据存放目录权限

mkdir -p /data/mysql;chown mysql.mysql -R /data/mysql

#安装 cmake

wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz

tar zxf cmake-2.8.4.tar.gz

cd cmake-2.8.4

./configure

make&make install

cd ..

tar zxf mysql-5.5.10.tar.gz

cd mysql-5.5.10

#预编译

cmake .

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql/

-DMYSQL_DATADIR=/data/mysql

-DMYSQL_UNIX_ADDR=/data/mysql/mysqld.sock

-DWITH_INNOBASE_STORAGE_ENGINE=1

-DENABLED_LOCAL_INFILE=1

-DMYSQL_TCP_PORT=3306

-DEXTRA_CHARSETS=all

-DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock

-DWITH_DEBUG=0

#编译、安装

make & make install

#复制配置文件

cp support-files/my-medium.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysqld

chmod 755 /etc/init.d/mysqld

chkconfig -add mysqld

chkconfig mysqld on

#初始化数据库

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql

#修改PATH

echo ''export PATH=$PATH:/usr/local/mysql/bin'' >> /etc/profile

#修改密码,附权

mysql>use mysql;

mysql>update user set password=PASSWORD("admin") where user=''root'';

mysql>grant all privileges on *.* to root@''%'' identified by "admin"with grant option;

mysql>create database jiradb;

mysql>create database confluencedb;

mysql>grant all privileges on jiradb.* to jirauser@''%'' identified by "admin"with grant option;

mysql>grant all privileges on confluencedb.* to jirauser@''%'' identified by "admin"with grant option;

mysql>FLUSH PRIVILEGES;

mysql> select host,user,password from mysql.user;

------ ---------- -------------------------------------------

| host | user | password |

------ ---------- -------------------------------------------

| % 数据库中表名大小写问题,在my.cnf中加入参数lower_case_table_names = 1,忽略大小写.

3. tail –f /jira_confluence/jira/logs/catalina.out

本文出自 “LOA” 博客,请务必保留此出处http://lj2007331.blog.51cto.com/979238/567248