centos 6.2 安装mysql-5.5.27

1

# yum install bison gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libtool-ltdl-devel*

# yum install bison gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libtool-ltdl-devel*

1
2
3
4
5
6
7

# wget http://www.cmake.org/files/v2.8/cmake-2.8.6.tar.gz
 
# tar zxvf cmake-2.8.6.tar.gz
# cd cmake-2.8.6/
# ./configure
# gmake
# gmake install

# wget http://www.cmake.org/files/v2.8/cmake-2.8.6.tar.gz # tar zxvf cmake-2.8.6.tar.gz # cd cmake-2.8.6/ # ./configure # gmake # gmake install

1
2
3

# useradd mysql
# mkdir -p /data/mysql
# chown -R root:mysql /data/mysql

# useradd mysql # mkdir -p /data/mysql # chown -R root:mysql /data/mysql

1
2
3
4
5
6
7

# wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.27.tar.gz/from/http://mysql.ntu.edu.tw/
 
# tar zxvf mysql-5.5.27.tar.gz
# cd mysql-5.5.27
# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/etc/
# gmake
# gmake install

# wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.27.tar.gz/from/http://mysql.ntu.edu.tw/ # tar zxvf mysql-5.5.27.tar.gz # cd mysql-5.5.27 # cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/etc/ # gmake # gmake install

1
2

# cd /usr/local/mysql
# cp ./support-files/my-huge.cnf /etc/my.cnf

# cd /usr/local/mysql # cp ./support-files/my-huge.cnf /etc/my.cnf

1

# vi /etc/my.cnf

# vi /etc/my.cnf

1
2
3
4
5

datadir = /data/mysql
wait-timeout = 30
max_connections = 512
max_connect_errors = 10000000
default-storage-engine = MyISAM

datadir = /data/mysql wait-timeout = 30 max_connections = 512 max_connect_errors = 10000000 default-storage-engine = MyISAM

1

max_allowed_packet = 16M

max_allowed_packet = 16M

1
2
3
4

# ./scripts/mysql_install_db --datadir=/data/mysql --basedir=/usr/local/mysql  --defaults-file=/etc/my.cnf --user=mysql
# cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 755 /etc/rc.d/init.d/mysqld
# chkconfig --add mysqld

# ./scripts/mysql_install_db --datadir=/data/mysql --basedir=/usr/local/mysql --defaults-file=/etc/my.cnf --user=mysql # cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld # chmod 755 /etc/rc.d/init.d/mysqld # chkconfig --add mysqld

1
2
3

# vi /etc/rc.d/init.d/mysqld
basedir=/usr/local/mysql
datadir=/data/mysql

# vi /etc/rc.d/init.d/mysqld basedir=/usr/local/mysql datadir=/data/mysql

1
2

# echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile （永久生效）
# export PATH=$PATH:/usr/local/mysql/bin （当前生效）

# echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile （永久生效） # export PATH=$PATH:/usr/local/mysql/bin （当前生效）

1

# service mysqld start

# service mysqld start

1
2

# mysqladmin -u root password '123456'
# service mysqld restart

# mysqladmin -u root password '123456' # service mysqld restart

1

# mysql -u root -p

# mysql -u root -p