cnetos63安装mysql5.5.30

一、安装mysql5.5.30
1、添加用户组和用户
groupadd mysql                                                               #添加用户组，名称mysql
useradd mysql -g mysql -s /sbin/nologin                           #添加用户名mysql，并把该用户隶属于mysql用户组
2、准备软件
yum install gcc                                                                #安装gcc编译器
yum install gcc-c++                                                         #安装gcc-c++编译器
yum install make                                                             #安装make编译器工具
yum install cmake                                                           #安装cmake编译工具
yum install ncurses-devel                                               #安装mysql5.5需要的软件包
yum install bison                                                             #安装mysql5.5需要的软件包
reboot                                                                             #重启系统
3、编译
cmake .                                                                           #使用cmake编译
make                                                                               #编译
make install                                                                     #安装
4、配置
cd /usr/local/mysql                                                           #进入mysql安装目录
chown mysql.mysql -R .                                                   #将mysql目录赋予mysql用户的执行权限
chown mysql.mysql -R ./data                                            #将mysql的data目录赋予mysql用户的执行权限
cp support-files/my-medium.cnf /etc/my.cnf                      #mysql配置文件
chmod 755 scripts/mysql_install_db                                #赋予mysql_install_db执行权限
scripts/mysql_install_db  --user=mysql  --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data  #初始化数据脚本
cp support-files/mysql.server /etc/init.d/mysqld               #复制mysqld到服务中
chmod 755 /etc/init.d/mysqld                                           #mysqld设置为可执行
chkconfig --list|grep mysqld                                             #检查是否开机启动
chkconfig mysqld on                                                        #设置为开机启动
service mysqld start
/usr/local/mysql/bin/mysqladmin -u root password 'yourpassword'      #设置root密码
/usr/local/mysql/bin/mysql -u root -p                                                    #敲入该命令后，屏幕会提示输入密码
mysql> use mysql;
mysql> delete from user where password='';
mysql> flush privileges;
mysql> grant all privileges on *.* to root@'%' identified by "root";       #把root改为可以成功登录
mysql> flush privileges;
mysql> select User,Password,Host from user;
mysql> quit;
二、安装apache2
yum -y install apr apr-util                                                                   #安装必要组件
cd /home/soft/
wget http://mirror.bjtu.edu.cn/apache//httpd/httpd-2.2.24.tar.bz2      #下载apache2
tar -xf httpd-2.2.24.tar.bz2                                                                #解压apache2
cd httpd-2.2.24                                                                                 #进入目录
./configure                                                                                        #配置编译
make && make install                                                                       #编译并安装
cp /opt/lamp/apache/bin/apachectl /etc/init.d/httpd                          #把apache2复制到/etc/init.d/下，可以开机自启动
vi /etc/init.d/httpd                                                                              #编辑启动文件
在#!/bin/sh后面加入下面两行
#chkconfig:345 85 15
#description: Start and stops the Apache HTTP Server.
chmod +x /etc/rc.d/init.d/httpd                                                          #给httpd增加执行权限
chkconfig --add httpd                                                                       #