Matthewl 发表于 2018-10-10 12:14:03

CentOS6.7下安装MySQL

  Step1: 检测系统是否自带安装mysql
# yum list installed | grep mysql  Step2: 删除系统自带的mysql及其依赖
  命令:
# yum -y remove mysql-libs.x86_64  Step3: 给CentOS添加rpm源,并且选择较新的源
  到MySQL官网上下载Linux版本的MySQL rpm 安装包。
http://img.blog.csdn.net/20160716160006933?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
  Step4: 将该压塑包解压后,有如下文件:
http://img.blog.csdn.net/20160716163348901?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
  Step5:安装文件,我们需要安装的文件有
  MySQL-server-5.6.26-1.linux_glibc2.5.i386.rpm、MySQL-client-5.6.26-1.linux_glibc2.5.i386.rpm、MySQL-devel-5.6.26-1.linux_glibc2.5.i386.rpm
  1、执行命令rpm -ivh MySQL-server-5.6.26-1.linux_glibc2.5.i386.rpm 安装server.
http://img.blog.csdn.net/20160716163419456?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
  由上图可以见,我们安装并没有成功,与系统原有的5.1.73版本的MySQL冲突了,怎么办呢? 山人自有妙计,执行命令yum -y remove mysql-libs-5.1.73* ,移除冲突的文件。
http://img.blog.csdn.net/20160716163542332?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
  移除冲突文件之后,我们再次执行命令rpm -ivh MySQL-server-5.6.26-1.linux_glibc2.5.i386.rpm 安装server.
http://img.blog.csdn.net/20160716163742506?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
  上面是安装MySQL server成功时所产生的日志,看到划红线的日志了么 ? 是的,会产生个随机密码给mysql root用户.
http://img.blog.csdn.net/20160716170341214?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
  2、安装client和devel文件.
http://img.blog.csdn.net/20160716163840871?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
  至此,MySQL已安装完成。
  启动MySQL , service mysql start .
http://img.blog.csdn.net/20160716164017635?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
  用上面文件里的随机密码就可以登录mysql 了。
http://img.blog.csdn.net/20160716170119508
  3、更改MySQL密码.
  执行如下语句可以修改MySQL的用户密码,当然前提是用那个随机密码登录进来.
  SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');
http://img.blog.csdn.net/20160716171550793


页: [1]
查看完整版本: CentOS6.7下安装MySQL