center os 6.5 安装mysql8

center os 6.5 安装mysql8

使用yum方法安装，先删除自带的mysql文件

windows下打开https://dev.mysql.com/downloads/repo/yum/，下载：

Red Hat Enterprise Linux 6 / Oracle Linux 6 (Architecture Independent), RPM Package		25.2K	Download
(mysql80-community-release-el6-1.noarch.rpm) 拷贝到centos系统中： rpm -Uvh mysql80-community-release-el6-1.noarch.rpm *因为默认安装mysql8，所以不需要做如下修改 yum-config-manager --disable mysql80-community yum-config-manager --enable mysql57-community 接下来安装mysqlserver yum install mysql-community-server 安装完，启动mysql server service mysqld start 取得mysql root的默认密码 grep 'temporary password' /var/log/mysqld.log 用默认密码登陆mysql mysql -uroot -p ALTER USER 'root'@'localhost' IDENTIFIED BY 'pass!'; 到此mysql已正常可用 新建用户，用于远程访问 create user 'admin'@'localhost' identified by 'pass!';  create user 'admin'@'%' identified by 'pa's's!';  grant all privileges on *.* to 'admin'@'%'; grant all privileges on *.* to 'admin'@'localhost'; 这样就可以远程访问了。 详细可参照： https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-fresh-install