CentOS下安装MySQL8.0.11系统(linux)CentOS7.4安装软件MySQL8.0.11下载mysqlyum源wgethttps://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpminstallyum源yumlocalinstallmysql80-community-release-el7-1.noarch.rpmupdateyumsourceyumcleanallyummakecachecreateMysqlaccountgroupaddmysqluseradd-gmysqlmysqlstartMySQLyuminstallmysql-community-serverstartMySQLsystemctlstartmysqld查看初始化密码cat/var/日志/mysqld.log|greppassword登录mysqlmysql-uroot-p修改初始化密码（密码必须是大小写字母+数字+符号，如：aa-123456789）ALTERUSER'root'@'localhost'IDENTIFIEDBY'你的密码';远程设置使用mysql；更新用户集host='%'whereuser='root';允许任何主机访问数据库GRANTALLPRIVILEGESON*.*TO'root'@'%'WITHGRANTOPTION;FLUSHPRIVILEGES;允许myuser用户使用mypassword密码从任何主机连接到mysql服务器GRANTALLPRIVILEGESON*.*TO'myuser'@'%'IDENTIFIEDBY'mypassword'WITHGRANTOPTION;允许用户myuser从ip192.168.1.6mysql服务器连接到主机，并使用mypassword作为密码GRANTALLPRIVILEGESON*.*TO'myuser'@'192.168.1.3'IDENTIFIEDBY'mypassword'WITHGRANTOPTION;错误信息ERROR1045(28000):拒绝用户'root'@'localhost'访问（使用密码：YES）serverisrunningwiththe--skip-grant-tablesoption所以它不能执行这条语句解决方法：刷新权限：flushprivileges;参考资料：CentOS7安装mysql8
