redhat6.5安装mysql8.0(升级)

本安装过程在redhat6.5版本上安装或升级mysql8.0，亲自实践，其他版本linux仅供参考，谢谢！

###新增目录

mkdir -p  *********/mysql_8.0.15/databases_bak

mkdir -p  *********/mysql_8.0.15/conf_bak

###备份数据库

mysqldump -u root -p ********* > *********/mysql_8.0.15/databases_bak/*********.sql

mysqldump -u root -p ********* > *********/mysql_8.0.15/databases_bak/*********.sql

###备份配置文件

cp /etc/my.cnf *********/mysql_8.0.15/conf_bak/

###停止数据库

service mysqld stop

###上传安装包

*********/mysql_8.0.15/mysql-8.0.15-1.el6.x86_64.rpm-bundle.tar

###解压

tar -xvf mysql-8.0.15-1.el6.x86_64.rpm-bundle.tar

###卸载旧版本

rpm -e mysql-community-devel-8.0.13-1.el6.x86_64 --nodeps

rpm -e mysql-community-common-8.0.13-1.el6.x86_64 --nodeps

rpm -e mysql-community-client-8.0.13-1.el6.x86_64 --nodeps

rpm -e mysql-community-libs-compat-8.0.13-1.el6.x86_64 --nodeps

rpm -e mysql-community-test-8.0.13-1.el6.x86_64 --nodeps

rpm -e mysql-community-libs-8.0.13-1.el6.x86_64 --nodeps

rpm -e mysql-community-server-8.0.13-1.el6.x86_64 --nodeps

###安装新版本（顺序安装）

rpm -ivh mysql-community-common-8.0.15-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.15-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-compat-8.0.15-1.el6.x86_64.rpm

rpm -ivh mysql-community-devel-8.0.15-1.el6.x86_64.rpm --force --nodeps

rpm -ivh mysql-community-client-8.0.15-1.el6.x86_64.rpm

rpm -ivh mysql-community-server-8.0.15-1.el6.x86_64.rpm

rpm -ivh mysql-community-test-8.0.15-1.el6.x86_64.rpm

###备份旧的/u1/mysql

tar -cvf mysql_20190317.tar *********/mysql

###新建mysql目录

mkdir -p *********/mysql/data

mkdir -p *********/mysql/mysqllog

mkdir -p *********/mysql/mysqldata

###恢复my.cnf

cp *********/mysql_8.0.15/conf_bak/my.cnf /etc/

###修改目录权限以及文件权限

chown -R mysql:mysql /*********/mysql

chown mysql:mysql /etc/my.cnf

###切换到mysql用户

su - mysql

###初始化mysql

mysqld --initialize --user=mysql --basedir=*********/mysql/

###设置免密登陆，

在/etc/my.cnf最后增加skip-grant-tables，没有就新增

###重启mysql

Service mysqld restart

###登陆mysql（此时不用输入密码）

mysql -u root -p

###查看用户密码

select host,user,authentication_string from mysql.user;

###修改登陆密码

GRANT ALL ON *.* TO 'root'@'%';

ALTER user 'root'@'%' IDENTIFIED BY 'qwe!@#123';（这种加密方式，之前的mysql客户端不支持）

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'qwe!@#123';

###注释免密登陆

在/etc/my.cnf注释掉skip-grant-tables

###重启mysql

Service mysqld restart

###登陆mysql

mysql -uroot -p qwe!@#123

###新建数据库

create database **********;

create database **********;

###导入备份数据库

use **********

source **********/databases_bak/*****20190315.sql

use **********

source **********/databases_bak/*****20190315.sql

-------------------redhat6.5  ------------------------------mysql8.0