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)