Linux安装MySQL 8.0.11

网上看了很多，有的写的不全，有的闭门造车，所以先整理些供大家参考
我安装的服务器的RedHat 6.5 ，64bit操作系统。
一、首先去官网
https://downloads.mysql.com/archives/community/
下载安装包，因为我选择的是mysql-8.0.11-1.el6.x86_64.rpm-bundle.tar RPM安装

下载之后解压得到7个文件：
1、mysql-community-client-8.0.11-1.el6.x86_64.rpm
2、mysql-community-common-8.0.11-1.el6.x86_64.rpm
3、mysql-community-devel-8.0.11-1.el6.x86_64.rpm
4、mysql-community-libs-8.0.11-1.el6.x86_64.rpm
5、mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm
6、mysql-community-server-8.0.11-1.el6.x86_64.rpm
7、mysql-community-test-8.0.11-1.el6.x86_64.rpm

二、安装
1、如果之前安装过mysql，建议先卸载赶紧,系统没安装过自动忽略
可以参考传送门https://www.cnblogs.com/taomylife/p/7234925.html
2、按顺序安装
[root@localhost ~]# rpm -ivh mysql-community-common-8.0.11-1.el6.x86_64.rpm
[root@localhost ~]# rpm -ivh mysql-community-libs-8.0.11-1.el6.x86_64.rpm
[root@localhost ~]# rpm -ivh mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm
[root@localhost ~]# rpm -ivh mysql-community-server-8.0.11-1.el6.x86_64.rpm
[root@localhost ~]# rpm -ivh mysql-community-client-8.0.11-1.el6.x86_64.rpm
[root@localhost ~]# rpm -ivh mysql-community-devel-8.0.11-1.el6.x86_64.rpm
[root@localhost ~]# rpm -ivh mysql-community-test-8.0.11-1.el6.x86_64.rpm
部分安装截图：

创建mysql 用户组：
useradd mysql
passwd mysql
安装完成后 查看MySQL信息
[root@localhost ~]# mysql -V
[root@localhost ~]# ll /etc/init.d/mysqld
[root@localhost ~]# ll /etc/my.cnf
其中datadir 位置可以在my.cnf中自行配置

MySQL启动、关闭等命令如下：

启动mysql
service mysqld start
关闭mysql
service mysqld stop
重新启动mysql
service mysqld restart
查看运行状态
service mysqld status

三、启动之后发现无法登陆：
在 my.cnf 添加 skip-grant-tables ，重启MySQL
登陆 mysql -uroot -p //提示输入密码后直接敲回车进去
选择数据库
use mysql
//将密码置空
update user set authentication_string = ” where user = ‘root’;
推出
exit

去除免密码登陆
删掉步骤1的语句 skip-grant-tables
重启服务 service mysqld restart

mysql -u root -p //提示输入密码时直接敲回车，刚刚已经将密码置空了
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘Abc123@xxx’;//密码需包含大写字母、小写字母，数字、特殊字符 ， 密码形式过于简单则会报错

四、创建远程访问权限
创建远程用户，及权限
create user test identified by ‘Test@123’;
ALTER USER ‘test’@’%’ IDENTIFIED WITH mysql_native_password BY ‘Test@123’;

SELECT * FROM USER WHERE USER=’test’;
SHOW GRANTS FOR test;
授予用户查询、修改、删除、增加 数据库权限
GRANT EXECUTE,INSERT,SELECT,UPDATE,DELETE ON dev_name.* TO ‘test’@’%’; //dev_name 为数据库名，test用户名
http://www.cnblogs.com/testway/p/9289827.html
grant 创建、修改、删除 MySQL 数据表结构权限
grant create on dev_name .* to test@’%’;
grant alter on dev_name .* to test@’%’;
grant drop on dev_name .* to test@’%’;

参考的连接：
https://downloads.mysql.com/archives/community/
https://www.linuxidc.com/Linux/2018-05/152409.htm
http://www.cnblogs.com/testway/p/9289827.html
https://blog.csdn.net/wen_z_j/article/details/80729489
https://www.cnblogs.com/goodhacker/p/3373213.html