在redhat 5上安装mysql5.5.8-huyoung 技术成就与梦想
*****************************************************************操作系统：Linux2.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下载并安装
# tar zxf cmake-2.8.3.tar.gz
# cd cmake-2.8.3
# ./bootstrap
# make
# make install
2、GNU make 3.75或更高版本
3、C++编译器， GCC 3.2 或更新版本
4、如果想运行测试脚本就安装perl
开始安装mysql5.5.8
1、下载源码mysql-5.5.8。
2、开始安装
# groupadd mysql
# useradd -r -g mysql mysql
# tar zxvf mysql-5.5.8.tar.gz
# cd mysql-5.5.8
# cmake .
# make
# make install
# cd /usr/local/mysql/
# chown -R mysql .
# scripts/mysql_install_db --user=mysql
# chown -R root .
# chown -R mysql data
# cp support-files/my-medium.cnf /etc/my.cnf
# bin/mysqld_safe --user=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
账户密码配置
# 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 | | |
+-----------+------+----------+
# bin/mysql -e "delete from mysql.user where User=''"
# bin/mysqladmin -u root password "cuijie"
# bin/mysql -e "update mysql.user set Password=password('cuijie') where User='root'"
OK 安装完毕
页:
[1]