Centos 6.5 Installation Atlassiana crowd+jira+confluence (Wiki) database chapter (MySQL5.1)

Software preparation

1. Database software

MySQL 5.1 main program

MySQL clinet connection Client

Mysql-devel drivers

Installation steps

• Installing the operating system

• Configure host Name

• Modify IP Address

• Modify system time-to-hold time accuracy

• Yum Installation Database

• Open the database and make relevant changes

• Open the appropriate port for the firewall

Modify Host Name

Vi/etc/sysconfig/network

Modify the hostname of hostname= you plan

Save and launch

650) this.width=650; "src=" http://s1.51cto.com/wyfs02/M00/8D/1B/wKiom1iGs-nS2Wk7AAAWkJci1CQ570.jpg "style=" float: none; "title=" image004.jpg "alt=" Wkiom1igs-ns2wk7aaawkjci1cq570.jpg "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/8D/1B/wKiom1iGs-nBiDoKAAAIC6IFkk4609.png "style=" float: none; "title=" Image005.png "alt=" Wkiom1igs-nbidokaaaic6ifkk4609.png "/>

Modify host IP Address

Vi/etc/sysconfig/network-scripts/ifcfg-eth0

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/8D/18/wKioL1iGs-qwixEAAAAthPvSD-0346.png "style=" width : 700px;height:272px; "title=" Image007.png "width=" "height=" "272" border= "0" hspace= "0" vspace= "0" alt= " Wkiol1igs-qwixeaaaathpvsd-0346.png "/>

Save the configuration file and restart the system for the computer name to take effect

Modify the system time

Rm-rf/etc/localtime
Yum Install-y ntpdate
Ntpdate us.pool.ntp.org
Ln-s/usr/share/zoneinfo/asia/shanghai/etc/localtime

Installing the Database

Yum install MySQL mysql-server mysql-devel-y

Configuration database

Service mysqld Start

mysqladmin-u root password ' new password (password) '

Modify the My.cnf file

Character-set-server=utf8

Default-storage-engine=innodb

max_allowed_packet=50000000
set-variable=max_allowed_packet=50000000

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/8D/18/wKioL1iGs-uB7bWiAAA-ugWWk6w848.png "style=" width : 700px;height:285px; "title=" Image009.png "width=" "height=" "285" border= "0" hspace= "0" vspace= "0" alt= " Wkiol1igs-ub7bwiaaa-ugwwk6w848.png "/>

Save the configuration and restart the database

Open firewall port

/sbin/iptables-i input-p TCP--dport 3306-j ACCEPT

/etc/init.d/iptables Save

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/8D/1B/wKiom1iGs-ySOpgCAAAfvkc1quo646.png "style=" width : 700px;height:84px; "title=" Image011.png "width=" "height=" + "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1igs-ysopgcaaafvkc1quo646.png "/>

The database installation is complete until the database is created

This article is from the "Wang Yalin" blog, make sure to keep this source http://tutorialhome.blog.51cto.com/10472846/1893991

Centos 6.5 Installation Atlassiana crowd+jira+confluence (Wiki) database chapter (MySQL5.1)