redhat 5.8安装mysql_在redhat 5上安装mysql5.5.8

*****************************************************************

操作系统：Linux  2.6.18-238.el5

Mysql版本：mysql-5.5.8.tar.gz

E-mail：jie_cui#139.com

Date：2011/1/27

*****************************************************************

注：

通过源码安装mysql5.5.8系统必须安装下列工具

1、cmake，可以从http://www.cmake.org/cmake/resources/software.html下载并安装

[root@cuijie tools]# tar zxf cmake-2.8.3.tar.gz

[root@cuijie tools]# cd cmake-2.8.3

[root@cuijie cmake-2.8.3]# ./bootstrap

[root@cuijie cmake-2.8.3]# make

[root@cuijie cmake-2.8.3]# make install

2、GNU make 3.75或更高版本

3、C++编译器， GCC 3.2 或更新版本

4、如果想运行测试脚本就安装perl

开始安装mysql5.5.8

1、下载源码mysql-5.5.8。

2、开始安装

[root@cuijie ~]# groupadd mysql

[root@cuijie ~]# useradd -r -g mysql mysql

[root@cuijie tools]# tar zxvf mysql-5.5.8.tar.gz

[root@cuijie tools]# cd mysql-5.5.8

[root@cuijie mysql]# cmake .

[root@cuijie mysql]# make

[root@cuijie mysql]# make install

[root@cuijie mysql]# cd /usr/local/mysql/

[root@cuijie mysql]# chown -R mysql .

[root@cuijie mysql]# scripts/mysql_install_db --user=mysql

[root@cuijie mysql]# chown -R root .

[root@cuijie mysql]# chown -R mysql data

[root@cuijie mysql]# cp support-files/my-medium.cnf /etc/my.cnf

[root@cuijie mysql]# bin/mysqld_safe --user=mysql &

[root@cuijie mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql.server

3、安装之后的配置和测试

查看mysql安装的版本信息

bin/mysqladmin version

查看mysql的变量信息

bin/mysqladmin variables

验证可以关闭掉服务

bin/mysqladmin -u root shutdown

验证可以启动服务

bin/mysqld_safe --user=mysql --log &

查看数据库信息

bin/mysqlshow

查看表的信息

bin/mysqlshow mysql

shell中使用sql语句进行查询

bin/mysql -e "SELECT Host,Db,User FROM db" mysql

账户密码配置

[root@cuijie mysql]# bin/mysql -e "select Host,User,Password from mysql.user"

+-----------+------+----------+

| Host      | User | Password |

+-----------+------+----------+

| localhost | root |          |

| cuijie    | root |          |

| 127.0.0.1 | root |          |

| ::1       | root |          |

| localhost |      |          |

| cuijie    |      |          |

+-----------+------+----------+

[root@cuijie mysql]# bin/mysql -e "delete from mysql.user where User=''"

[root@cuijie mysql]# bin/mysqladmin -u root password "cuijie"

[root@cuijie mysql]# bin/mysql -e "update mysql.user set Password=password('cuijie') where User='root'"

OK 安装完毕