CentOS 5.5 编译安装MySQL 5.5

CentOS 5.5 编译安装MySQL 5.5

环境：

[root@www.bkjia.com ~]# lsb_release -a

LSB Version:    :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: CentOS
Description:    CentOS release 5.5 (Final)
Release:        5.5
Codename:       Final

1.下载安装cmark
下载地址: http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
# cd cmake-version
# ./configure
# make
# make install

2.下载安装mysql
下载地址： http://www.mysql.com/downloads/mysql/
# groupadd mysql
# useradd -r -g mysql mysql
# tar zxvf mysql-VERSION.tar.gz
# cd mysql-VERSION
# cmake .
# make
# make install
# cd /usr/local/mysql
# chown -R mysql .
# chgrp -R mysql .
# scripts/mysql_install_db --user=mysql
# chown -R root .
# chgrp -R mysql data
# cp support-files/my-medium.cnf /etc/my.cnf
# bin/mysqld_safe --user=mysql &
# cp support-files/mysql.server /etc/init.d/mysql.server

安装完成后可能登陆root用户没有设置密码，因此要设置密码
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql

mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
mysql>show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)