1.安装make编译器
下载地址: http://www.gnu.org/software/make/
- tar zxvf make-3.82.tar.gz
- cd make-3.82
- ./configure
- make
- make install
tar zxvf make-3.82.tar.gz cd make-3.82 ./configure make make install
2.安装bison
下载地址:http://www.gnu.org/software/bison/
- tar zxvf bison-2.5.tar.gz
- cd bison-2.5
- ./configure
- make
- make install
tar zxvf bison-2.5.tar.gz cd bison-2.5 ./configure make make install
3.安装gcc-c++
下载地址:http://www.gnu.org/software/gcc/
- tar zxvf gcc-c++-4.4.4.tar.gz
- cd gcc-c++-4.4.4
- ./configure
- make
- make install
tar zxvf gcc-c++-4.4.4.tar.gz cd gcc-c++-4.4.4 ./configure make make install
4.安装cmake
下载地址:http://www.cmake.org/
- tar zxvf cmake-2.8.4.tar.gz
- cd cmake-2.8.4
- ./configure
- make
- make install
tar zxvf cmake-2.8.4.tar.gz cd cmake-2.8.4 ./configure make make install
5.安装ncurses
下载地址:http://www.gnu.org/software/ncurses/
- tar zxvf ncurses-5.8.tar.gz
- cd ncurses-5.8
- ./configure
- make
- make install
tar zxvf ncurses-5.8.tar.gz cd ncurses-5.8 ./configure make make install
开始安装MySQL,下载地址:http://dev.mysql.com/
http://dev.mysql.com/downloads/mysql/5.5.html#downloads
选择平台为 source code
准备工作
- groupadd mysql
- useradd -r -g mysql mysql
groupadd mysql useradd -r -g mysql mysql
解压并安装MySQL
- tar zxvf mysql-5.5.13.tar.gz
- cd mysql-5.5.13
- cmake . /
- -DCMAKE_INSTALL_PREFIX=/usr/local/mysql /
- -DINSTALL_DATADIR=/usr/local/mysql/data
- make
- make install
tar zxvf mysql-5.5.13.tar.gz cd mysql-5.5.13 cmake . / -DCMAKE_INSTALL_PREFIX=/usr/local/mysql / -DINSTALL_DATADIR=/usr/local/mysql/data make make install
完成后,继续下面的操作
- cd /usr/local/mysql
- chown -R mysql .
- chgrp -R mysql .
- scripts/mysql_install_db --user=mysql
- chown -R root .
cd /usr/local/mysql chown -R mysql . chgrp -R mysql . scripts/mysql_install_db --user=mysql chown -R root .
下面的命令是可选的,将mysql的配置文件拷贝到/etc
- cp support-files/my-medium.cnf /etc/my.cnf
cp support-files/my-medium.cnf /etc/my.cnf
启动mysql:
- bin/mysqld_safe --user=mysql &
- #启动mysql,看是否成功
- netstat -tnl|grep 3306
bin/mysqld_safe --user=mysql & #启动mysql,看是否成功 netstat -tnl|grep 3306
上面是一种启动mysql的方法,还有一种简单的方便,如下:
- #将mysql的启动服务添加到系统服务中
- cp support-files/mysql.server /etc/init.d/mysql.server
- #现在可以使用下面的命令启动mysql
- service mysql.server start
- #停止mysql服务
- service mysql.server stop
- #重启mysql服务
- service mysql.server restart
#将mysql的启动服务添加到系统服务中 cp support-files/mysql.server /etc/init.d/mysql.server #现在可以使用下面的命令启动mysql service mysql.server start #停止mysql服务 service mysql.server stop #重启mysql服务 service mysql.server restart
将mysql服务添加到开机启动项,让mysql服务开机启动
- chkconfig --add mysql.server
chkconfig --add mysql.server
重启机器后,mysql服务就会自动启动了。
如果报错:
[@tc_157_61 mysql]# service mysql.server start
Starting MySQL.The server quit without updating PID file (/usr/local/mysql/data/tc_157_61.pid).[FAILED]
则赋权限给data
[@tc_157_61 mysql]# chmod 777 data
[@tc_157_61 mysql]# service mysql.server start
Starting MySQL...[ OK ]
(7)修改MySQL的root用户的密码以及打开远程连接
[root@ rhel5~]# mysql -u root mysql
mysql>use mysql;
mysql>desc user;
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root"; //为root添加远程连接的能力。
mysql>update user set Password = password('xxxxxx') where User='root';
mysql>select Host,User,Password from user where User='root';
mysql>flush privileges;
mysql>exit
重新登录:mysql -u root -p
若还不能进行远程连接,则关闭防火墙
[root@ rhel5~]# /etc/rc.d/init.d/iptables stop
注:如果不能远程连接,出现错误mysql error number 1130,则加入下面语句试试:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '******' WITH GRANT OPTION;
红色的部分是真正的安装步骤。