centos7 安装mysql8.0

在mysql官网获取yum源安装包
http://dev.mysql.com/downloads/repo/yum/
复制下载链接地址为：
mysql80-community-release-el7-3.noarch.rpm

# 下载和安装
wget http://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
rpm -ivh mysql80-community-release-el7-3.noarch.rpm
yum install mysql-community-server -y

# 卸载mysql
yum remove mysql-community-server

# 查看，如果有查询结果，使用【 yum remove 名称 】清理掉
rpm -qa|grep mysql
yum remove xxx

# 再使用命令查看 rpm -qa | grep -i mysql，如果有查询结果， 使用 【 rpm -e 名称 】 卸载
rpm -qa | grep -i mysql
rpm -e xxx

# 删除文件
rm -rf /var/lib/mysql
rm /etc/my.cnf
rm -rf /usr/share/mysql-x.x

# 如果开启了防火墙，想开启远程访问，需要开放防火墙端口
sudo firewall-cmd --permanent --zone=public --add-port=3306/tcp
sudo firewall-cmd --reload

# 启动mysql
service mysqld start

# 关闭mysql
service mysqld stop

# 查看启动状态
service mysqld status

# 重启mysql
service mysqld restart

# 设置开机启动
systemctl enable mysqld
systemctl daemon-reload

# 查看下mysql的版本，确定是否安装成功
mysql -V

# 查看默认密码
sudo grep 'temporary password' /var/log/mysqld.log

# 进入mysql
mysql -u root
mysql> use mysql;

# 修改密码
mysql> UPDATE user SET password=password("密码") WHERE user='root';   # mysql 7.0
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '密码'; # mysql 8.0
mysql> flush privileges;

# 开启本地访问
mysql> grant all privileges on *.* to root@"localhost" identified by "密码";

# 开启远程访问
mysql> grant all privileges on *.* to root@"%" identified by "密码"; # mysql 7.0
mysql> UPDATE user SET host = '%' WHERE user ='root; # mysql 8.0
mysql> flush privileges; # 刷新MySQL的系统权限相关表

# 退出
mysql> exit


# 允许输入控制
mysql> SET GLOBAL sql_mode = '';

# 创建数据库表
mysql> CREATE DATABASE IF NOT EXISTS doctor DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
mysql> USE doctor;

# 修改配置文件，让其可以无账号登录。 默认配置文件为 my.cnf， 添加如下命令 skip-grant-tables
vi /etc/my.cnf
skip-grant-tables

# 重启 mysql 
service mysqld restart

# 登录 mysql （无密码登录即可）
mysql -uroot -p

# 添加用户
mysql> insert into user(User,authentication_string,ssl_cipher,x509_issuer,x509_subject) values('root','','','','');
# 添加权限
mysql> update user set Host='localhost',select_priv='y', insert_priv='y',update_priv='y',Alter_priv='y',delete_priv='y',create_priv='y',drop_priv='y',reload_priv='y',shutdown_priv='y',Process_priv='y',file_priv='y',grant_priv='y',References_priv='y',index_priv='y',create_user_priv='y',show_db_priv='y',super_priv='y',create_tmp_table_priv='y',Lock_tables_priv='y',execute_priv='y',repl_slave_priv='y',repl_client_priv='y',create_view_priv='y',show_view_priv='y',create_routine_priv='y',alter_routine_priv='y',create_user_priv='y' where user='root';commit;

# 去掉最开始添加的命令，重启mysql服务 
vi /etc/my.cnf
# skip-grant-tables
service mysqld restart

# 重新登录，使用root账号，设置密码
mysql> use mysql;
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '密码';
mysql> flush privileges;
mysql> exit;