操作系统版本信息:
CentOS release 6.7 (Final)
Kernel \r on an \m
安装步骤:
1、查看操作系统信息
#cat /etc/issue
#uname -a
2、下载软件包
#mkdir tools
先删除自带的rpm包
#rpm -qa | grep mysql
#yum -y remove mysql-libs-5.1*
#rpm -qa | grep mysql
3、下载安装需要的rpm包
#cd tools
#wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.21-1.rhel5.x86_64.rpm
#wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-devel-5.6.21-1.rhel5.x86_64.rpm
#wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.21-1.rhel5.x86_64.rpm
下载完成之后有三个安装包
MySQL-client-5.6.21-1.rhel5.x86_64.rpm
MySQL-server-5.6.21-1.rhel5.x86_64.rpm
MySQL-devel-5.6.21-1.rhel5.x86_64.rpm
4、安装rpm包:
#rpm -ivh MySQL-server-5.6.21-1.rhel5.x86_64.rpm
在安装的时候报错:
error: Failed dependencies:
/usr/bin/perl is needed by MySQL-server-5.6.21-1.rhel5.x86_64
libaio.so.1()(64bit) is needed by MySQL-server-5.6.21-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.6.21-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.6.21-1.rhel5.x86_64
这是因为依赖的问题,解决方式:
#yum install -y perl-Module-Install.noarch
#yum install -y libaio
现在开始安装rpm包:
#rpm -ivh MySQL-server-5.6.21-1.rhel5.x86_64.rpm
#rpm -ivh MySQL-client-5.6.21-1.rhel5.x86_64.rpm
#rpm -ivh MySQL-devel-5.6.21-1.rhel5.x86_64.rpm
5、修改配置文件位置:
#cp /usr/share/mysql/my-default.cnf /etc/my.cnf
6、启动服务:
#cd /usr/bin
#./mysqld_safe &
7、修改MySQL默认的密码:
#/usr/bin/mysql_install_db
#ps -ef | grep mysql
#netstat -anpt | grep 3306
#more /root/.mysql_secret
#mysql -uroot -p
回车后提示输入密码,将more /root/.mysql_secret命令执行后得到的密码输入就可以了,登录后就直接进入了MySQL,然后修改登录密码
->set PASSWORD=PASSWORD('ABC123');
关于mysql服务的开启与关闭
检查mysql服务是否启动:
ps -ef | grep mysql
(1)关闭服务:
#mysqladmin -u root shutdown
#service mysql stop
(2)开启服务:
#service mysql start
#service mysql restart
或
#cd /usr/bin
#./mysqld_safe &
设置服务的开机启动:
#chkconfig mysql on
#chkconfig mysql --list