Shulou(Shulou.com)06/01 Report--

Software preparation

1. Database software

Mysql 5.1 main program

Mysql clinet connection client

Mysql-devel driver

Installation steps

Install the operating system

Configure the host name

Modify IP address

Modify the system time to keep the time accuracy

Yum installation database

Open the database and make related changes

Open the corresponding port of the firewall

Modify host name

Vi / etc/sysconfig/network

Modify the hostname of your plan for HOSTNAME=

Save and launch

Modify host IP address

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

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

Modify system time

Rm-rf / etc/localtime

Yum install-y ntpdate

Ntpdate us.pool.ntp.org

Ln-s / usr/share/zoneinfo/Asia/Shanghai / etc/localtime

Install the database

Yum install mysql mysql-server mysql-devel-y

Configuration database

Service mysqld start

Mysqladmin-u root password 'new password'

Modify the my.cnf file

Character-set-server=utf8

Default-storage-engine=InnoDB

Max_allowed_packet=50000000

Set-variable=max_allowed_packet=50000000

Save the configuration and restart the database

Open the firewall port

/ sbin/iptables-I INPUT-p tcp-- dport 3306-j ACCEPT

/ etc/init.d/iptables save

At this point, the database installation is complete, waiting for the database to be created.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.